How to export all repeater data in excel file

below is the link might be helpful

 

 

Ref this : http://www.aspsnippets.com/Articles/Export-GridView-all-pages-with-Paging-enabled-AllowPaging-to-Excel-in-ASPNet.aspx

Hi,

 

Ref this : http://www.aspsnippets.com/Articles/Export-GridView-all-pages-with-Paging-enabled-AllowPaging-to-Excel-in-ASPNet.aspx 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

public partial class dropdowngrid : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

GetDataTable();

}

}

private void GetDataTable()

{

DataTable dt = new DataTable();

dt.Columns.Add("ID", typeof(string));

dt.Columns.Add("Name", typeof(string));

dt.Columns.Add("Designation", typeof(string));

DataRow dr = dt.NewRow();

dr["ID"] = "1";

dr["Name"] = "Amit";

dr["Designation"] = "HR";

dt.Rows.Add(dr);

DataRow dr1 = dt.NewRow();

dr1["ID"] = "2";

dr1["Name"] = "Sumit";

dr1["Designation"] = "Accounts";

dt.Rows.Add(dr1);

Repeater1.DataSource = dt;

Repeater1.DataBind();

}

protected void btnok_Click(object sender, EventArgs e)

{

string style = @"";

string file = "sheet";

Response.ClearContent();

Response.AddHeader("content-disposition", "attachment;filename=" + file + ".xls");

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

htmlWrite.WriteLine("
");

htmlWrite.WriteLine("" + "Date: " + DateTime.Now.ToShortDateString() + "");

htmlWrite.WriteLine("
");

//htmlWrite.WriteLine("" + "Salary Register for the Month of " + txtMonthYear.Text + "");

htmlWrite.WriteLine("
");

htmlWrite.WriteLine("
");

Repeater1.RenderControl(htmlWrite);

htmlWrite.WriteLine("
");

Response.Write(style);

Response.Write(stringWrite.ToString());

Response.End();

}

}

Hi try like below code

 

private void exportProcessRequesttoExcel()
{
Response.Clear();
Response.ContentType = "application/ms-excel"; //"application/vnd.xls";
Response.AddHeader("content-disposition", "attachment;filename=ServiceRequest.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);

using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);

//To Export all pages
gvServiceProcess.AllowPaging = false;

//fill your data like below method

this.getSericeRequest();

gvServiceProcess.HeaderRow.BackColor = System.Drawing.Color.Gray;
gvServiceProcess.HeaderRow.ForeColor = System.Drawing.Color.White;
foreach (TableCell cell in gvServiceProcess.HeaderRow.Cells)
{
cell.BackColor = gvServiceProcess.HeaderStyle.BackColor;
}
foreach (GridViewRow row in gvServiceProcess.Rows)
{
row.BackColor = System.Drawing.Color.White;
foreach (TableCell cell in row.Cells)
{
cell.HorizontalAlign = HorizontalAlign.Left;
cell.VerticalAlign = VerticalAlign.Top;
if (row.RowIndex % 2 == 0)
{
cell.BackColor = gvServiceProcess.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = gvServiceProcess.RowStyle.BackColor;

}
cell.CssClass = "textmode";
}
}

gvServiceProcess.RenderControl(hw);

//style to format numbers to string
string style = @"";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}

}

or try below link

http://www.aspsnippets.com/Articles/Export-ASPNet-Repeater-Control-to-Excel-File.aspx

http://www.codeproject.com/Tips/772285/Export-Data-from-Repeater-Datagrid-to-Excel 

read this link

 

 

 

it may help you