Skip to main content
Row

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.
See Also