Skip to main content
A newer version of this page is available. .
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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this method in production code.