Export Data Table to Excel

 

Below i express you how to export data table to excel sheet, this should works with SharePoint and .Net Appications

string attachment = “attachment; filename=QueryViewer_Export.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();

Advertisements

Author: eshan1604

Hi Guys, I'm Udara Eshan Ariyarathne from Sri Lanka. Currently i'm working as a Software Engineer (Microsoft Technologies). I'm sharing some IT related articles such as Development ,Configuration and Designing things what i have learn from day to day works. Hope it useful all of us. "Enjoying IT" Thanks & Regards, Udara Eshan Ariyarthne

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s