WorksheetExtensions.Import(Worksheet, Object[], Int32, Int32, Boolean, IDataValueConverter) Method

Imports data from an one-dimensional array of objects.

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,
    object[] array,
    int firstRowIndex,
    int firstColumnIndex,
    bool isVertical,
    IDataValueConverter converter
)

<ExtensionAttribute>
Public Shared Sub Import(
    sheet As Worksheet,
    array As Object(),
    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.

| | array | Object[] |

A one-dimensional array of objects that is the data source.

| | 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 one-dimensional array and enables you to process data before insertion in a worksheet and to specify how to place the data in cells - vertically or horizontally.