Export the gridview data to excel

manish kedar

Hello sir,

I want to export gridview data to excel in asp.net but this process can't happen b'coz one exception occured on response.end(). And the grid also have the row delete button give me some solution for that process and how to handle 'thread begin aborted' exception on response.end() method.

3 Replies

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

Leon D8y ago
Hi,

This article might help you:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html
0
manish kedar8y ago
Thank you sir..
+1
Aniket Rana8y ago
You Can Export Direct Datatable
> Coding Through set Datatable to Export in Excel
> You Can't Export Whole Gridview

> For Example ..

dt = city.GetAllCity();//your datatable
string attachment = "attachment; filename=city.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();
+1