WorksheetExtensions.Import(Worksheet, DataTable, Boolean, Int32, Int32, DataImportOptions) Method
Imports data from a data table.
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Docs.v24.1.dll
NuGet Package: DevExpress.Document.Processor
Declaration
public static void Import(
this Worksheet sheet,
DataTable source,
bool addHeader,
int firstRowIndex,
int firstColumnIndex,
DataImportOptions options
)
Parameters
Name | Type | Description |
---|---|---|
sheet | Worksheet | A Worksheet that is the worksheet to which the data is imported. |
source | DataTable | A DataTable object that is the data source for import. |
addHeader | Boolean | true, to insert column names to the row above the cells containing imported data; otherwise, false. |
firstRowIndex | Int32 | An integer that is the row index of the start cell in which the imported data will be inserted. |
firstColumnIndex | Int32 | An integer that is the column index of the start cell in which the imported data will be inserted. |
options | DataImportOptions | A DataImportOptions object containing data import options, parameters and converter. |
Remarks
The Import imports data from a data table and enables you to process data before insertion in a worksheet.