How to create a table in excel from datatable in C#

Question

I have to create the table in excel from the existing datatable and need to create a pivot table for the given column in the tale .

Bhavesh Jadav · Accepted Answer

Hello Veda,   Please refer below link to create a table in excel from a data table  https://www.codeproject.com/Articles/406704/Export-DataTable-to-Excel-with-Formatting-in-Cshar Thanks.

Leon D · Answer

Hi veda vinothini,   Use Spire.XLS, you can easily achieve this, the code is very simple.   Refer the following article:   DataTable to Excel: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html    Create Pivot Table:  https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Pivot-Table-Create-Pivot-Table-in-Excel-with-C-/VB.NET.html