Back to Devexpress

WorksheetExtensions.Import Method

officefileapi-devexpress-dot-spreadsheet-dot-worksheetextensions-dot-import.md

latest22.5 KB
Original Source

WorksheetExtensions.Import Method

NameParametersDescription
Import(Worksheet, Boolean[], Int32, Int32, Boolean) staticsheet, 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.

|