WorksheetExtensions.Import(Worksheet, IEnumerable, Int32, Int32, Boolean) Method
Imports data from a collection.
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,
IEnumerable source,
int firstRowIndex,
int firstColumnIndex,
bool isVertical
)
Parameters
Name | Type | Description |
---|---|---|
sheet | Worksheet | A Worksheet that is the worksheet to which the data is imported. |
source | IEnumerable | An object that exposes the IEnumerable interface provided by a collection of objects being imported. |
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. |
isVertical | Boolean | true, to insert imported data vertically; otherwise, false |
Remarks
The following code snippet illustrates how to use the Import method.
' Create a List object containing string values.
Dim cities As New List(Of String)()
cities.Add("New York")
cities.Add("Rome")
cities.Add("Beijing")
cities.Add("Delhi")
' Import the list into the worksheet and insert it vertically, starting with the B1 cell.
worksheet.Import(cities, 0, 1, True)
The image below shows the results.