Export Data from Database to An Existing Excel Sheet asp.net

Hi Ayush,

Firstly you get your data from the database into grid view using collection on the web page, then you can add button on web page 'btnExport'. After that, you can add below code into your backend page.cs.

protected void btnExportGrid_Click(object sender, EventArgs e)

{

ExportGridToExcel();

}

private void ExportGridToExcel()

{

Response.Clear();

Response.Buffer = true;

Response.ClearContent();

Response.ClearHeaders();

Response.Charset = "";

string FileName = "yourFileName" + DateTime.Now + ".xls";

StringWriter strwritter = new StringWriter();

HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);

Gridview1.GridLines = GridLines.Both;

Gridview1.HeaderStyle.Font.Bold = true;

Gridview1.RenderControl(htmltextwrtter);

Response.Write(strwritter.ToString());

Response.End();

}

public override void VerifyRenderingInServerForm(Control control)

{

/* Verifies that the control is rendered */

}

your Excel file is downloaded after clicking on the Export button.

Thank you!

1 Reply

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

Kiran Girase8y ago
Hi Ayush,

Firstly you get your data from the database into grid view using collection on the web page, then you can add button on web page 'btnExport'. After that, you can add below code into your backend page.cs.

protected void btnExportGrid_Click(object sender, EventArgs e)

{

ExportGridToExcel();

}

private void ExportGridToExcel()

{

Response.Clear();

Response.Buffer = true;

Response.ClearContent();

Response.ClearHeaders();

Response.Charset = "";

string FileName = "yourFileName" + DateTime.Now + ".xls";

StringWriter strwritter = new StringWriter();

HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.ms-excel";

Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);

Gridview1.GridLines = GridLines.Both;

Gridview1.HeaderStyle.Font.Bold = true;

Gridview1.RenderControl(htmltextwrtter);

Response.Write(strwritter.ToString());

Response.End();

}

public override void VerifyRenderingInServerForm(Control control)

{

/* Verifies that the control is rendered */

}

your Excel file is downloaded after clicking on the Export button.

Thank you!