.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

WorksheetExtensions.Import Method

Name Parameters Description
Import(Worksheet, Boolean[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of boolean values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Boolean[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of boolean values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Byte[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of bytes.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Byte[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of bytes.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, IEnumerable, Int32, Int32, Boolean) static sheet, source, firstRowIndex, firstColumnIndex, isVertical

Imports data from a collection.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, IEnumerable, Int32, Int32, Boolean, DataImportOptions) static sheet, source, firstRowIndex, firstColumnIndex, isVertical, options

Imports data from a collection.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, IEnumerable, Int32, Int32, Boolean, IDataValueConverter) static sheet, source, firstRowIndex, firstColumnIndex, isVertical, converter

Imports data from a collection.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, DataTable, Boolean, Int32, Int32) static sheet, source, addHeader, firstRowIndex, firstColumnIndex

Imports data from a data table.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, DataTable, Boolean, Int32, Int32, DataImportOptions) static sheet, source, addHeader, firstRowIndex, firstColumnIndex, options

Imports data from a data table.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, DataTable, Boolean, Int32, Int32, IDataValueConverter) static sheet, source, addHeader, firstRowIndex, firstColumnIndex, converter

Imports data from a data table.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, IDataReader, Boolean, Int32, Int32) static sheet, source, addHeader, firstRowIndex, firstColumnIndex

Imports data from a relational database.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, IDataReader, Boolean, Int32, Int32, DataImportOptions) static sheet, source, addHeader, firstRowIndex, firstColumnIndex, options

Imports data from a relational database.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, IDataReader, Boolean, Int32, Int32, IDataValueConverter) static sheet, source, addHeader, firstRowIndex, firstColumnIndex, converter

Imports data from a relational database.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, DateTime[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of DateTime values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, DateTime[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of DateTime values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Decimal[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of decimal values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Decimal[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of decimal values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Double[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of double-precision floating point values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Double[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of double-precision floating point values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Int16[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of short integers.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Int16[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of integers.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Int32[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of integers.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Int32[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of integers.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Int64[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of long integers.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Int64[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of long integers.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object, Int32, Int32) static sheet, dataSource, firstRowIndex, firstColumnIndex

Imports data from a data source.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object, Int32, Int32, DataSourceImportOptions) static sheet, dataSource, firstRowIndex, firstColumnIndex, options

Imports data from a data source.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of objects.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object[], Int32, Int32, Boolean, DataImportOptions) static sheet, array, firstRowIndex, firstColumnIndex, isVertical, options

Imports data from an one-dimensional array of objects.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object[], Int32, Int32, Boolean, IDataValueConverter) static sheet, array, firstRowIndex, firstColumnIndex, isVertical, converter

Imports data from an one-dimensional array of objects.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of objects.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object[,], Int32, Int32, DataImportOptions) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex, options

Imports data from a two-dimensional array of objects.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Object[,], Int32, Int32, IDataValueConverter) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex, converter

Imports data from a two-dimensional array of objects.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Single[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of single-precision floating point values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, Single[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of single-precision floating point values.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, String[], Int32, Int32, Boolean) static sheet, array, firstRowIndex, firstColumnIndex, isVertical

Imports data from an one-dimensional array of strings.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, String[,], Int32, Int32) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex

Imports data from a two-dimensional array of strings.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Import(Worksheet, String[,], Int32, Int32, DataImportOptions) static sheet, twoDimensionalArray, firstRowIndex, firstColumnIndex, options

Imports data from a two-dimensional array of strings.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.