.NET Excel Library
Export Data to Excel in C# and VB.NET

Export from data tables to Excel

Data from ADO.NET objects such as data tables, data columns, and data views are exported to Excel worksheets. This option enables you to export:

• To a specific cell or named range.
• Data with or without headers.
• Data based on value type of first row of a column or value type in each cell of a data column.
• Data as hyperlinks.
• Large amounts of data in seconds.

Export from array to Excel

Export one-dimensional or two-dimensional arrays to an Excel worksheet. This also enables you to export:

• To a specific cell.
• As a one-dimensional array, either vertically or horizontally.
• Data as hyperlinks.

Export a collection to Excel

Export a collection with desired data to an Excel worksheet This enables you to export:

• From N number of collections.
• From nested collections.
• Data with or without headers.
• Images.
• Data as hyperlinks.

Export from databases to Excel

Export data from databases like SQL and Access. Data that is updated in the database will reflect in the Excel table.

Export from CSV or TSV to Excel

Comma-separated value (CSV) files and tab-separated value (TSV) files are helpful in generating lightweight reports with few columns and a high number of rows, quickly. Excel Library supports opening and saving CSV and TSV files with a few lines of code.

• CSV documentation
• TSV documentation

Export from Microsoft Grid controls to Excel

Exporting data from Microsoft Grid controls such as DataGrid, GridView, and DataGridView to an Excel worksheet is very simple. You can export:

• From a specific cell range in an Excel worksheet.
• By preserving it.
• With or without a header.
• With grid styles.

• DataGrid-to-Excel documentation
• GridView-to-Excel documentation
• DataGridView-to-Excel documentation