Back to Devexpress

WorksheetExtensions Members

officefileapi-devexpress-dot-spreadsheet-dot-worksheetextensions-dot-underscore-members.md

latest27.9 KB
Original Source

WorksheetExtensions Members

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.

Methods

NameDescription
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

WorksheetExtensions Class

DevExpress.Spreadsheet Namespace