public static void ExportExel(System.Data.DataTable data, string fileName)
{
HttpContext context = HttpContext.Current;
context.Response.Clear();
context.Response.ContentType = "text/csv";
context.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".csv");
//rite column header names
for (int i = 0; i < data.Columns.Count; i++)
{
if (i > 0)
{
context.Response.Write(",");
}
context.Response.Write(data.Columns[i].ColumnName);
}
context.Response.Write(Environment.NewLine);
//Write data
foreach (DataRow row in data.Rows)
{
for (int i = 0; i < data.Columns.Count; i++)
{
if (i > 0)
{
context.Response.Write(",");
}
context.Response.Write(row.ItemArray[i].ToString());
}
context.Response.Write(Environment.NewLine);
}
context.Response.End();
}
2020-01-31