Export multiple gridview to excel

Vignesh Kumar

12y7.6k.NET

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.Count; i++)
    {
        GridView1.HeaderRow.Cells[i].Style.Add("background-color", "#aaaaaa");
    }
    GridView1.RenderControl(htw);
    Response.Write(sw.ToString());
    Response.End();
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sagar Pardeshi12y ago
Accepted 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 Montes11y ago
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 Kumar12y ago
Hi Sagar,

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

Export multiple gridview to excel

Report

" + DateTime.Now.ToString("d") + "