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

csharp

public static void Import(
    this Worksheet sheet,
    IEnumerable source,
    int firstRowIndex,
    int firstColumnIndex,
    bool isVertical,
    IDataValueConverter converter
)

<ExtensionAttribute>
Public Shared Sub Import(
    sheet As Worksheet,
    source As IEnumerable,
    firstRowIndex As Integer,
    firstColumnIndex As Integer,
    isVertical As Boolean,
    converter As IDataValueConverter
)

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

| | 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.