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