how to convert DataTable to Excel sheet and save into server

Question

Hi All, in C# I want to convert data table into excel sheet and save into server folder.

Jignesh Kumar · Answer

Please find below link for convert datatable to excel just need to apply save logic, https://www.aspsnippets.com/Articles/Export-DataTable-DataSet-to-Excel-file-in-ASPNet-MVC.aspx https://forums.asp.net/t/2066840.aspx?Best+way+to+export+data+from+a+Datatable+to+Excel+using+C+

Sreekanth Reddy · Answer

Hi Ravi, You I think you might be know about the data conversion to excel. Please try to take the reference of below link for image dispalying in excel https://www.aspsnippets.com/Articles/Export-Image-to-Excel-file-in-ASPNet-using-C-and-VBNet.aspx Thank you. Mark as answer, If it helps.

Rajesh Kumar · Answer

I need export datatable in excel With image in asp.net without using gridview??/

Lisa White · Answer

well, check this: http://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-datatable-to-excel-in-C-Sharp-using-interop/ http://stackoverflow.com/questions/1746701/export-datatable-to-excel-file?rq=1

Ravi Patel · Answer

Hi Lisa, thanks for reply i can not purchase the Spire.doc license so is there any other way to do this

Lisa White · Answer

Hi, Check this: http://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/How-to-Export-Datatable-to-Excel-through-DataGridView.html

how to convert DataTable to Excel sheet and save into server

Answers (6)