Skip to main content
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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a 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 a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.