Back to Devexpress

WorksheetExtensions.Import(Worksheet, IEnumerable, Int32, Int32, Boolean, IDataValueConverter) Method

officefileapi-devexpress-dot-spreadsheet-dot-worksheetextensions-dot-import-x28-worksheet-ienumerable-int32-int32-boolean-idatavalueconverter-x29.md

latest3.4 KB
Original Source

WorksheetExtensions.Import(Worksheet, IEnumerable, Int32, Int32, Boolean, IDataValueConverter) 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.v25.2.dll

NuGet Package : DevExpress.Document.Processor

Declaration

csharp
public static void Import(
    this Worksheet sheet,
    IEnumerable source,
    int firstRowIndex,
    int firstColumnIndex,
    bool isVertical,
    IDataValueConverter converter
)
vb
<ExtensionAttribute>
Public Shared Sub Import(
    sheet As Worksheet,
    source As IEnumerable,
    firstRowIndex As Integer,
    firstColumnIndex As Integer,
    isVertical As Boolean,
    converter As IDataValueConverter
)

Parameters

NameTypeDescription
sheetWorksheet

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

| | converter | IDataValueConverter |

An object that implements the IDataValueConverter interface for data conversion.

|

Remarks

The Import imports data from a collection and enables you to process data before insertion in a worksheet.

See Also

How to: Import Data to a Worksheet in SpreadsheetControl for WinForms

WorksheetExtensions Class

WorksheetExtensions Members

DevExpress.Spreadsheet Namespace