This quick tutorial will guide you on how to convert DataTable to Excel in C#. First, we will create a DataTable and then import it into the worksheet of the newly created workbook object using the ImportData function of WorkSheet.Cells class. After writing DataTable data to Excel in C#, we will save it as an XLSX file on the disc.

Steps to Convert DataTable to Excel in C#

1. Using the NuGet package manager, add Aspose.Cells for .NET to import DataTable into Excel
2. Create an instance of an empty Workbook for exporting DataTable to it
3. Create and initialize a DataTable for writing to Excel file
4. Declare an object of ImportTableOptions class for setting parameters while importing data from DataTable
5. Get a reference to the first worksheet in the newly created workbook
6. Call the Cells.ImportData function in the WorkSheet class to import DataTable
7. Save the resultant Workbook having data from the DataTable

These steps describe the process to export data from DataTable to Excel in C# in a step-by-step manner such that first the empty workbook is created and then a DataTable is initialized and filled with some dummy data. An object of ImportTableOptions class is created that contains a lot of parameters that can be set, however here the default options are used. In the end, the DataTable is imported into the first worksheet of the Workbook at a specified starting cell.

Code to Export DataTable Data to Excel in C#

In this code, ImportTableOptions is used with default settings however, you can set a variety of parameters like a list of 0 index based column numbers whose data is to be imported from the DataTable, set the date format, set total rows and columns to be imported, and many more. You can also decide whether column titles are to be imported or not.

This short tutorial has explained how in C# create Excel file from DataTable. If you want to learn the reverse process like Convert Excel to DataTable, refer to the article on how to convert Excel to DataTable in C#.