WorksheetExtensions Methods
Defines extension methods for the Worksheet interface.
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use these methods in production code.
Name | Description |
---|---|
CreateDataTable(Worksheet, CellRange, Boolean, Boolean) static |
Creates an empty data table from the specified cell range. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateDataTable(Worksheet, CellRange, Boolean) static |
Creates an empty data table from the specified cell range. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateDataTableExporter(Worksheet, CellRange, DataTable, Boolean) static |
Creates an instance of the data table exporter. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateThumbnail(Worksheet, Int32, Int32, WorksheetThumbnailOptions) static |
Save the worksheet as an image. Allows you to specify the image size and thumbnail options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateThumbnail(Worksheet, Int32, Int32) static |
Saves the worksheet as an image with the specified size. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateThumbnail(Worksheet, Stream, ImageFileFormat, Int32, Int32, WorksheetThumbnailOptions) static |
Saves the worksheet as an image in the specified format. Allows you to specify the image size and thumbnail options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateThumbnail(Worksheet, Stream, ImageFileFormat, Int32, Int32) static |
Saves the worksheet as an image in the specified format and allows you to set the image size. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateThumbnail(Worksheet, String, ImageFileFormat, Int32, Int32, WorksheetThumbnailOptions) static |
Saves the worksheet as an image in the specified format. Allows you to specify the image size and thumbnail options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
CreateThumbnail(Worksheet, String, ImageFileFormat, Int32, Int32) static |
Saves the worksheet as an image in the specified format and allows you to set the image size. You need a license for the DevExpress Office File API Subscription 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 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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. |
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. |