Hi here is some sample of code of converting DataTable to Excel
protected void DataTableToExcel()
{
Response.Clear();
Response.ClearHeaders();
DataTable dt = (DataTable)(Session["dtExport"]);
string html = GenerateHTMLTable(dt);
Response.AddHeader("Content-Disposition", "attachment;filename="+Request.QueryString["page"]+".xls");
Response.ContentType = "application/vnd.ms-excel";
Response.Write(html);
Response.Flush();
Response.Close();
Response.End();
}
private string GenerateHTMLTable(DataTable dt)
{
StringBuilder sb = new StringBuilder();
sb.Append("
");
sb.Append("");
foreach (DataColumn dc in dt.Columns)
{
sb.Append("");
sb.Append(dc.ColumnName);
sb.Append(" | ");
}
sb.Append("
");
foreach (DataRow dr in dt.Rows)
{
sb.Append("");
foreach (object obj in dr.ItemArray)
{
if (isDateTime(obj.ToString()))
{
string format = GetFormat(obj.ToString());
sb.Append("");
sb.Append(obj.ToString());
sb.Append("\",\"");
sb.Append(format);
sb.Append("\")");
}
else
{
sb.Append(" | ");
sb.Append(obj.ToString());
}
sb.Append(" | ");
}
sb.Append("
");
}
sb.Append("
");
return sb.ToString();
}
Enter your message below
Sign in or Join us (it's free).