WorksheetExtensions.Import(Worksheet, Object, Int32, Int32, DataSourceImportOptions) Method
Imports data from a data source.
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,
object dataSource,
int firstRowIndex,
int firstColumnIndex,
DataSourceImportOptions options
)
Parameters
Name | Type | Description |
---|---|---|
sheet | Worksheet | A Worksheet that is the worksheet to which the data is imported. |
dataSource | Object | An object that is the data source for import. |
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 | DataSourceImportOptions | A DataSourceImportOptions object specifying filed names to import. |
Remarks
You can specify object properties to import, as illustrated in the following code snippet..
Example
Dim list As New List(Of TestObject)()
list.Add(New TestObject(1, "1", True))
list.Add(New TestObject(2, "2", False))
worksheet.Import(list, 0, 0, New DataSourceImportOptions() With {
.PropertyNames = New String() { "BoolValue", "IntValue" }
})