Best Way to Export data to Excel

Jasbeer Singh9y ago

Hi Jaco,

I have written a blog for this. Please have a look it will surely help you.

http://www.c-sharpcorner.com/blogs/dataset-to-excel-export-xlsx

0

Jaco Zwarts10y ago

Thank you Alex I'll have a look.

0

Alex Smith10y ago

Check following links:

http://www.e-iceblue.com/Tutorials/Spire.DataExport/Spire.DataExport-Program-Guide/Export-Data-from-Listview-to-Excel-with-C-/VB.NET.html

http://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-generic-listt-to-excel-in-C-Sharp-using-interop/

http://stackoverflow.com/questions/2206279/exporting-the-values-in-list-to-excel

0

Shubham Kumar10y ago

Depending on the environment you're wanting to do this in, it is possible by using the Excel Interop. It's quite a mess dealing with COM however and ensuring you clear up resources else Excel instances stay hanging around on your machine.

0