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.v25.2.dll

NuGet Package : DevExpress.Document.Processor

csharp

public static void Import(
    this Worksheet sheet,
    DataTable source,
    bool addHeader,
    int firstRowIndex,
    int firstColumnIndex,
    DataImportOptions options
)

<ExtensionAttribute>
Public Shared Sub Import(
    sheet As Worksheet,
    source As DataTable,
    addHeader As Boolean,
    firstRowIndex As Integer,
    firstColumnIndex As Integer,
    options As DataImportOptions
)

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.