|
User Guide FAQ How to export DataTable to Excel file in C# and VB.NET
|
|
|
How to export DataTable to Excel file in C# and VB.NET
|
Concept
EasyXLS™
library allows you to export a DataTable to an Excel file. The data in cells can be formatted using predefined formats or user-defined formats.
EasyXLS can be successfully used inclusively to export large Excel files having big volume of data with fast exporting time.
Concept in action
Step 1: Download and install EasyXLS Excel Library for .NET
To download the trial version of EasyXLS Excel Library, press the below button:
If you already own a license key, you may login and download EasyXLS from your account.
Step 2: Create a C# or VB.NET project
If don't have a project, create one as ASP.NET web application, windows forms app, console application, class library or service.
Step 3: Include EasyXLS library into project
EasyXLS.dll must be added as reference to your project. EasyXLS.dll can be found after installing EasyXLS, in "Dot NET version" folder.
Step 4: Run C# or VB.NET code that exports DataTable to Excel
The below example shows how to export DataTable to Excel in C# and VB.NET.
|
Source code sample
|
|
|
|
|
|
|
DataTable dataTable = new DataTable();
DataColumn[] columns = {new DataColumn("ID"), new DataColumn("Value")};
Object[] row1 = {"1", "Value1"};
Object[] row2 = {"2", "Value2"};
Object[] row3 = {"3", "Value3"};
dataTable.Columns.AddRange(columns);
dataTable.Rows.Add(row1);
dataTable.Rows.Add(row2);
dataTable.Rows.Add(row3);
DataSet dataSet = new DataSet();
dataSet.Tables.Add(dataTable);
EasyXLS.ExcelDocument workbook = new EasyXLS.ExcelDocument();
workbook.easy_WriteXLSXFile_FromDataSet(
"C:\\Samples\\DataTable to Excel.xlsx",
dataSet,
new EasyXLS.ExcelAutoFormat(EasyXLS.Constants.Styles.AUTOFORMAT_EASYXLS1),
"DataTable");
workbook.Dispose();
dataSet.Dispose();
|
View more code samples...
|
|
|
|
Dim dataTable As DataTable = New DataTable
Dim columns As DataColumn() = {New DataColumn("ID"), New DataColumn("Value")}
Dim row1 As Object() = {"1", "Value1"}
Dim row2 As Object() = {"2", "Value2"}
Dim row3 As Object() = {"3", "Value3"}
dataTable.Columns.AddRange(columns)
dataTable.Rows.Add(row1)
dataTable.Rows.Add(row2)
dataTable.Rows.Add(row3)
Dim dataSet As DataSet = New DataSet
dataSet.Tables.Add(dataTable)
Dim workbook As EasyXLS.ExcelDocument = New EasyXLS.ExcelDocument
workbook.easy_WriteXLSXFile_FromDataSet( _
"C:\\Samples\\DataTable to Excel.xlsx", _
dataSet, _
New EasyXLS.ExcelAutoFormat(EasyXLS.Constants.Styles.AUTOFORMAT_EASYXLS1), _
"DataTable")
workbook.Dispose()
dataSet.Dispose()
|
View more code samples...
|
|
|
|
|
|
Export DataTable to Excel file with multiple sheets
For an Excel file having multiple sheets, the DataTable can be inserted using ExcelWorksheet.easy_insertDataSet method and the Excel file must be exported using ExcelDocument.easy_WriteXLSXFile method.
|
Formatting cells
EasyXLS™ enables you to format cells, rows and columns in order to set the fonts and colors.
|
Export DataTable to XLSX, XLSB, XLSM and XLS files
This code sample shows how to export a DataTable to XLSX file. Similarly, you can export a DataTable to XLS file using ExcelDocument.easy_WriteXLSFile_FromDataSet method or export DataTable to XLSB file using ExcelDocument.easy_WriteXLSBFile_FromDataSet method.
|
Getting started with EasyXLS Excel library
To download the trial version of EasyXLS Excel Library, press the below button:
|
|
If you already own a license key, you may login and download EasyXLS from your account.
After installation, you will need to create a C# or VB.NET project and add a reference to EasyXLS.dll.
|
|
|
|
Available for: Professional, Excel Writer, Express Excel Writer
|
