|
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
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_WriteXLSFile_FromDataSet(
"C:\\Samples\\DataTable to Excel.xls",
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_WriteXLSFile_FromDataSet( _
"C:\\Samples\\DataTable to Excel.xls", _
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_WriteXLSFile 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 XLS file. In a similar way, you can export a DataTable to XLSX file using ExcelDocument.easy_WriteXLSXFile_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
|
