Export DataTable to Excel File

Question

I have a DataTable with 30+ columns and 6500+ rows.I need to dump the whole DataTable values into an Excel file.Can anyone please help with the C# code.I need each column value to be in a cell.To be precise,I need the exact looking copy of DataTable in an Excel File.Please help.

Thanks, Vix

Answer 1

use this code...

    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();