How to export all repeater data in excel file

Question

I want to export all repeater data into excel file. I used this code but I got only one page data so I want to get all records (all pages).please help me. Response.Clear(); Response.Buffer = true; Response.AddHeader(content-disposition attachment;filename=Detail.xls); Response.Charset = ; Response.ContentType = application/vnd.ms-excel; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); rptrdata.RenderControl(htmlWrite); Response.Write( ); Response.Write(stringWrite.ToString()); Response.Write( ); Response.End();

Sumit Joshi · Answer

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

Rajeesh Menoth · Answer

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

Hemlata Kushwaha · Answer

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 = @ .text {mso-number-format:\@;} ; 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(); } }

Amit Jagtap · Answer

I have one problem I download excel file but it is not coming proper format means excel cell does not apply border means separation please give some solution.

Khan Abrar Ahmed · Answer

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 = @ .textmode { } ; 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

Nanhe Siddique · Answer

read this link http://www.aspsnippets.com/Articles/Export-ASPNet-Repeater-Control-to-Excel-File.aspx it may help you