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

1. Add Interop References. First we need to add a reference for Microsoft.office.interop.Excel as in the following:
2. Create a DataTable dynamically.
3. Class file for generating Excel. ...
4. Creation of Excel objects. ...
5. Initialization of Excel objects. ...
6. Writing to Excel file. ...
7. Working with range and formatting Excel cells. ...
8. Coloring cells.