Export DataTable to Excel sheet

Hi Shaik

It will be much easier to answer if tyou share the code .and where you get errors

Although let me try to give you the solution .Hope it work

Try using System.Web.HttpContext.Current.Response

using System.IO;
using System.Data;
using ClosedXML.Excel;
using System.Configuration;
using System.Data.SqlClient;

or you can visit following link

https://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-datatable-to-excel-in-C-Sharp-using-interop/

https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-export-datatable-to-excel/501

https://www.aspsnippets.com/Articles/Export-DataTable-to-Excel-in-ASPNet-using-C-and-VBNet.aspx

use this code as fun to export your data...

dt = city.GetAllCity(); //data filled from your service or fun//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();

4 Replies

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

Brajesh Kumar8y ago
Accepted answer
Hi Shaik

It will be much easier to answer if tyou share the code .and where you get errors

Although let me try to give you the solution .Hope it work

Try using System.Web.HttpContext.Current.Response
using System.IO;

using System.Data;

using ClosedXML.Excel;

using System.Configuration;

using System.Data.SqlClient;

or you can visit following link
https://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-datatable-to-excel-in-C-Sharp-using-interop/

https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-export-datatable-to-excel/501

https://www.aspsnippets.com/Articles/Export-DataTable-to-Excel-in-ASPNet-using-C-and-VBNet.aspx

use this code as fun to export your data...
dt = city.GetAllCity(); //data filled from your service or fun//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();
0
Leon D8y ago
Export data table to excel/excel to data table is very easy with free spire.xls library. You can get free spire.xls library from NuGet and refer to the following article:

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html
+1
Shaik Vahid8y ago
I missed CODEXML namespace. Now i added dll to project and it's working.

Thanks for your reply.
+1
Raghavendar Swaminathan8y ago
Hi Shaik,

Please show the error which VS is throwing.

Thanks
Raghav
0