WorksheetExtensions Methods
Defines extension methods for the Worksheet interface.
You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use these methods in production code. Refer to the DevExpress Subscription page for pricing information.
| Name | Description |
|---|---|
| CreateDataTable(Worksheet, Range, Boolean, Boolean) static |
Creates an empty data table from the specified cell range. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this method in production code. |
| CreateDataTable(Worksheet, Range, Boolean) static |
Creates an empty data table from the specified cell range. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this method in production code. |
| CreateDataTableExporter(Worksheet, Range, DataTable, Boolean) static |
Creates an instance of the data table exporter. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this method in production code. |
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| Import(Worksheet, Boolean[], Int32, Int32, Boolean) static |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| ToString() | Returns a string that represents the current object. Inherited from Object. |