Export multiple gridview to excel

Question

Hi I am using two grids in a page and I want to export those two grids on export to excel. I use the below code to export a single gridview and it works fine. Can anyone suggest me on how to achieve export for two grid views. protected void btnExport_Click(object sender EventArgs e) { Response.ClearContent(); Response.Buffer = true; Response.AddHeader(content-disposition string.Format(attachment; filename= {0} Reports.xls)); Response.ContentType = application/ms-excel; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); GridView1.AllowPaging = false; GridView1.DataBind(); //Change the Header Row back to white color GridView1.HeaderRow.Style.Add(background-color #FFFFFF); //Applying stlye to gridview header cells for (int i = 0; i { GridView1.HeaderRow.Cells[i].Style.Add(background-color #aaaaaa); } GridView1.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); }

Sagar Pardeshi · Answer

Hi  Follow below Code it's working for multiple grid view export to excel protected void exportBtn_ClickAv(object sender ImageClickEventArgs e) { try { GridView[] gvList = null; gvList = new GridView[] { GridView1 GridView2}; ExportAv(Reports.xls gvList); } catch (Exception ex) { ; } } public static void ExportAv(string fileName GridView[] gvs) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.AddHeader(content-disposition string.Format(attachment; filename={0} fileName)); HttpContext.Current.Response.ContentType = application/ms-excel; System.IO.StringWriter sw = new System.IO.StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); foreach (GridView gv in gvs) { gv.AllowPaging = false; // Create a form to contain the grid Table table = new Table(); table.GridLines = gv.GridLines; // add the header row to the table if (!(gv.Caption == null)) { TableCell cell = new TableCell(); cell.Text = gv.Caption; cell.ColumnSpan = 10; TableRow tr = new TableRow(); tr.Controls.Add(cell); table.Rows.Add(tr); } if (!(gv.HeaderRow == null)) { table.Rows.Add(gv.HeaderRow); } // add each of the data rows to the table foreach (GridViewRow row in gv.Rows) { table.Rows.Add(row); } // add the footer row to the table if (!(gv.FooterRow == null)) { table.Rows.Add(gv.FooterRow); } // render the table into the htmlwriter table.RenderControl(htw); } // render the htmlwriter into the response string headerTable = @ Report  + DateTime.Now.ToString(d) +  ; HttpContext.Current.Response.Write(headerTable); HttpContext.Current.Response.Write(sw.ToString()); HttpContext.Current.Response.End(); }

Eugene Montes · Answer

Vignesh unfortunately you cannot use this approach for PDF as well you see you're not actually creating an excel file but rather a HTML content which is exported as a file with XLS extension. This trick is usefully because most of the Excel applications can read HTML content and will be able to show it as expected but the same trick cannot be applied for PDF files. So instead you will need to generate a real PDF file there are few ways you can do that and one of them is with this .NET library for excel files . It can enable you to convert the HTML content (like your sw.ToString()) into an Excel file in .net  but also you can convert the Excel content into a PDF file in .net . And last you can directly export your Excel and/or PDF files to ASP.NET's client .

Vignesh Kumar · Answer

Hi Sagar It worked great. Is there any possible way to do it for pdf like excel.