download datatable into excel format using c#

Question

hello! i have accessed the datatable from server and now i want that user may download it in excel form please help me for coding

Sunny Sharma · Answer

Hi Veer, Use the code below: ---------------------------------- namespace DtToExcel { public class DtToExcel { public static void GetInExcel(System.Data.DataTable dtin, string StrFileName) { StringBuilder StrCol = new StringBuilder(); try { foreach (DataColumn Col in dtin.Columns) { StrCol.Append(Col.ColumnName + ","); } } catch (Exception ex) { throw new ArgumentException("Error :" + ex.Message); } GenerateExcellSheet(StrCol.ToString(), dtin, StrFileName); } private static void GenerateExcellSheet(string cols, System.Data.DataTable dt, string fname) { new StringBuilder(); Application NewExcelApp = new ApplicationClass(){ Visible = false }; _Workbook NewWorkBook = NewExcelApp.Workbooks.Add(Missing.Value); _Worksheet NewWorkSheet = (_Worksheet)NewWorkBook.ActiveSheet; string[] StrColumnNameArray = cols.Split(new char[] { ',' }); for (int i = 0; i { int j = i + 1; NewWorkSheet.Cells[1, j] = StrColumnNameArray[i].ToString(); } for (int i = 0; i { for (int j = 0; j { NewWorkSheet.Cells[i + 2, j + 1] = dt.Rows[i][j].ToString(); } } NewWorkSheet.SaveAs(fname + ".xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); NewWorkBook.Close(Missing.Value, Missing.Value, Missing.Value); NewWorkSheet = null; NewWorkBook = null; NewExcelApp.Quit(); } } } ----------------------------------------------------- I've also attached a compiled DLL of the same code to make you go with ease. Just refer the DLL file in your project and call it like: DtToExcel. GetInExcel(mydataTable,myFileName); ----------------------------------------------------- Hope it helps :)

Sanjeeb Lenka · Answer

Hi, Refer to this link it may help you http://www.c-sharpcorner.com/UploadFile/1a81c5/export-datatable-to-excel-with-formatting-in-C-Sharp/

download datatable into excel format using c#

Answers (2)