Workbook Members
#Constructors
Name | Description |
---|---|
Workbook() | Initializes a new instance of the Workbook class with the default settings. |
#Properties
Name | Description |
---|---|
Chart |
Provides access to a collection of chart sheets contained in the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Clipboard |
Provides access to the object used for working with the system clipboard. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Color |
Returns a color palette for the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Current |
Gets the system username. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Custom |
Provides access to a collection of custom functions in a workbook You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Custom |
Provides access to a workbook’s collection of custom XML parts. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Defined |
Gets the collection of defined names whose scope is the current workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Document |
Provides access to the document properties associated with a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Document |
Provides access to the settings that specify how the calculation is performed and what reference style is used. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
External |
Provides access to the collection of source workbooks used for creating external references in the current workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Formula |
Provides access to an object used to parse and evaluate formulas. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Functions |
Provides access to the built-in functions in a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Global |
Provides access to a collection of custom functions which are not limited in scope to the workbook in which the functions reside. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Has |
Determines whether the workbook has VBA projects (macros). You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
History |
Provides access to the history of operations performed in a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Is |
Indicates whether a workbook has been disposed of. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Is |
Indicates whether a workbook is protected. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Is |
Returns a value indicating whether the Workbook object is locked for update. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Mail |
Gets or sets a specific data member in a data source that contains several tables or members. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Mail |
Gets or sets the data source for the mail merge. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Mail |
Provides access to mail merge options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Mail |
Provides access to a collection of query parameters used to obtain data in mail merge. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Model | For internal use. |
Modified |
Gets or sets whether the workbook content was modified since it was last saved. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Options |
Returns an object that contains document options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Path |
Gets the file name into which the workbook is saved or from which it is loaded. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Pivot |
Returns the collection of all Pivot You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Range |
Provides access to the cell range in the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Real |
Returns an object used to manually update real-time data and reconnect to data servers. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Sheets |
Provides access to a collection of all sheets contained in the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Styles |
Provides access to the workbook’s collection of cell styles. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Table |
Provides access to the collection of styles to format tables in the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Tag |
Gets or sets data associated with a Workbook object. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Theme |
Returns the theme applied to the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Unit |
Gets or sets a unit of measure used in the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Worksheets |
Returns the collection of worksheets in a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
#Methods
Name | Description |
---|---|
Add |
Adds the specified service to the service container. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Add |
Adds the specified service to the service container. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Add |
Adds the specified service to the service container. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Add |
Adds the specified service to the service container. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Begin |
Locks the Workbook object until the Workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Calculate() |
Forces recalculation of the workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Calculate |
Forces recalculation of the specified cell range in a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Calculate |
Forces recalculation of the specified worksheet in a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Calculate |
Forces a full calculation of a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Calculate |
Forces a full calculation of a workbook and rebuilds the dependencies. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Cancel |
For internal use. Use the Workbook. |
Create |
Creates and loads a new empty workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Dispose() |
Releases resources associated with a Workbook instance. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
End |
Unlocks the Workbook object. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Evaluate |
Evaluates the specified formula in a certain context. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Evaluate |
Evaluates the specified formula. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the specified range to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the specified worksheet to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the document’s data to the specified stream in HTML format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the specified worksheet to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the specified range to the specified file in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the specified worksheet to the specified file in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the document’s data to the specified file in HTML format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the specified worksheet to the specified file in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified cell range to a stream in HTML format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified cell range to a stream in HTML format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified range to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified range to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a stream in HTML format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a stream in HTML format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified range to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports document data to a stream in HTML format. Allows you to specify export options and implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports document data to a stream in HTML format. Allows you to specify export options, implement progress notifications, and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the document’s data to the specified stream in HTML format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the document’s data to the specified stream in HTML format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a stream in HTML format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a stream in HTML format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified range to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified cell range to a file in HTML format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified cell range to a file in HTML format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified range to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a file in HTML format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a file in HTML format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to the specified file in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to the specified file in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports document data to a file in HTML format. Allows you to specify export options and implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports document data to a file in HTML format. Allows you to specify export options, implement progress notifications, and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the document’s data to the specified file in HTML format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the document’s data to the specified file in HTML format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a file in HTML format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to a file in HTML format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to the specified stream in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified worksheet to the specified file in HTML format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and exports the specified sheets to the stream in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and exports the specified sheets to the stream in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the workbook to the specified stream in PDF format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the workbook to the specified stream in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and exports the specified sheets to the file in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and exports the specified sheets to the file in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the workbook to the specified file path in PDF format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Exports the workbook to the specified file path in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified sheets to a stream in PDF format. Allows you to specify export options and implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified sheets to a stream in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and asynchronously exports the specified sheets to the stream in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified file path in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a stream in PDF format. Allows you to specify export options and implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports specific worksheets to the specified file path in PDF format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a stream in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified stream in PDF format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified stream in PDF format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a stream in PDF format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a stream in PDF format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified stream in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified stream in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified sheets to a file in PDF format. Allows you to specify export options and implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the specified sheets to a file in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and asynchronously exports the specified sheets to the file in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and asynchronously exports the specified sheets to the file in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a file in PDF format. Allows you to specify export options and implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Defines export options and asynchronously exports the specified sheets to the file in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a file in PDF format. Allows you to specify export options, implement progress notifications, and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified file path in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified stream in PDF format using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a file in PDF format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to a file in PDF format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified file path in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Export |
Asynchronously exports the workbook to the specified file path in PDF format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Generate |
Performs a mail merge and returns the collection of resulting workbooks. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Gets the service object of the specified type. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Get |
Gets the specified service. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Load |
Loads a document in the specified format from a byte array. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document from a byte array. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document in the specified format from a stream. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document from a stream. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document in the specified format from a file. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document from a file. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document in the specified format from a byte array and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document in the specified format from a byte array. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously in the specified format from a byte array. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously in the specified format from a byte array. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document from a byte array and allows you to implement progress notifications. The file format is determined based on document content You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document from a byte array (the file format is determined based on document content). Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously from a byte array. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously from a byte array. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document in the specified format from a stream and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document in the specified format from a stream. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously in the specified format from a stream. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously in the specified format from a stream. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document from a stream and allows you to implement progress notifications. The file format is determined based on document content. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document from a stream (the file format is determined based on document content). Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously from a stream. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously from a stream. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document in the specified format from a file and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document in the specified format from a file. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously in the specified format from a file. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously in the specified format from a file. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document from a file and allows you to implement progress notifications. The file format is determined based on document content. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Asynchronously loads a document from a file (the file format is determined based on document content). Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously from a file. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads a document asynchronously from a file. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads document properties for a workbook from the specified byte array. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads document properties for a workbook from the specified byte array. The document format is determined automatically. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads document properties for a workbook from the specified stream. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads document properties for a workbook from the specified stream. The document format is determined automatically. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads document properties from the specified workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Load |
Loads document properties from the specified workbook. The document format is determined automatically. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Merge |
Combines the specified workbooks into a new document. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Print() |
Prints the document to the default printer. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Print |
Defines cross-platform printer settings and prints the specified sheets. |
Print |
Defines cross-platform printer settings and prints the specified sheets. |
Print |
Defines printer settings and prints the workbook. |
Print |
Defines printer settings and prints the specified sheets. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Print |
Defines printer settings and prints the specified sheets. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Print |
Prints the document using the specified printer settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Protect |
Protects the structure and windows of a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
Remove |
Removes the service of the specified type from the service container. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Remove |
Removes the service of the specified type from the service container. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Replace |
Performs a service substitution. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves the document to an array of bytes in the specified format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves a document to a byte array in the specified format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves the document to a stream in the specified format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves the document to a stream in the specified format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves the document to a file in the specified format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves the document to a file in the specified document format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves the document to a file in the Excel or text format with the specified encryption settings. The file format is identified by the file extension. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Saves the document to a file in the Excel or text format. The file format is identified by the file extension. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a byte array in the specified file format, encrypts the output with a password, and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a byte array in the specified format and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to an array of bytes in the specified format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to an array of bytes in the specified format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a byte array in the specified format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a byte array in the specified format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to an array of bytes in the specified document format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a byte array in the specified document format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified format, encrypts the file with a password, and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified format and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified document format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified document format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified document format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a stream in the specified document format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified format, encrypts the file with a password, and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified format and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified document format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified format and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified format. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified document format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified document format. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file (the file format is defined by the file extension), encrypts the file with a password, and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file (the file format is defined by the file extension) and encrypts the file with a password. Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the specified format and with the specified encryption settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file with the specified encryption settings. The file format is identified by the file extension. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file (the file format is defined by the file extension) and allows you to implement progress notifications. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file (the file format is defined by the file extension). Allows you to implement progress notifications and cancel the operation. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Save |
Asynchronously saves the document to a file in the Excel or text format. The file format is identified by the file extension. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Search |
Performs a search in the current document by using the specified options. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
Search |
Performs a search in the current document by using the default parameters. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
To |
Returns a string that represents the current object. Inherited from Object. |
Unprotect |
Removes protection from a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code. |
#Events
Name | Description |
---|---|
Active |
Occurs after an active worksheet in a workbook has been changed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Active |
Occurs when an active worksheet in a workbook is about to be changed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Before |
Occurs before detecting the encoding of the loaded CSV or TXT data. |
Before |
Occurs before the document is saved (exported to a certain format). You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Before |
Occurs before a document is loaded (imported from an external source). You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Before |
Occurs before printing a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Clipboard |
Occurs after data on the clipboard is obtained and recognized, but before data is actually pasted. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Clipboard |
Occurs after data has been pasted from the clipboard onto a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Clipboard |
Occurs before data is pasted into destination cells. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Columns |
Occurs after new columns have been added to a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Columns |
Occurs before new columns are added to a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Columns |
Occurs after columns have been deleted from a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Columns |
Occurs before columns are removed from a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Column |
Occurs after the column width was changed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Comment |
Occurs after a comment was inserted. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Comment |
Occurs before a comment is inserted. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Comment |
Occurs after a comment was deleted. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Comment |
Occurs before a comment is deleted. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Content |
Occurs when a workbook’s undo history changes. The Undo history is not logged for a Workbook instance by default, so the event is not raised. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Copied |
Occurs after the range content has been pasted into target cells. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Copied |
Occurs before the range content is pasted into target cells. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Custom |
Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge. Allows you to cancel loading. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Defined |
Occurs when the formula or sheet being moved or copied contains a defined name which already exists on the destination worksheet or workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Document |
Occurs when a document that has not yet been saved is about to be closed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Document |
Occurs after a document is loaded. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Document |
Occurs after a document has been saved. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Empty |
Occurs when a new document is created. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Encrypted |
Raises when the encrypted file did not pass the data integrity verification. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Encrypted |
Occurs when the encryption password is empty or invalid. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Encrypted |
Raises when the Workbook You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Initialize |
Occurs before a document is loaded. Handle this event to set initial document settings. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Invalid |
Fires when the supplied data could not be recognized as data in the assumed format for import. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Modified |
Occurs when the value of the Workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Panes |
Occurs after a worksheet area has been frozen. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Panes |
Occurs after a frozen worksheet area has been unlocked. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Range |
Occurs after the range content has been copied. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Range |
Occurs before a cell range is copied in a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Row |
Occurs after the row height was changed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Rows |
Occurs after new rows have been added to a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Rows |
Occurs before new rows are added to a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Rows |
Occurs after rows have been deleted from a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Rows |
Occurs before rows are removed from a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Schema |
Occurs when a worksheet or defined name is renamed, inserted or deleted. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Scroll |
Occurs when the scroll position changes in a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Selection |
Fires when the selection changes in a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Shape |
Occurs after a drawing object has been inserted into a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Shape |
Occurs after a drawing object has been removed from a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Shape |
Occurs before a drawing object is removed from a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Shapes |
Occurs before a drawing object is copied in a worksheet. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Sheet |
Occurs after a new worksheet has been added to a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Sheet |
Occurs after a worksheet has been removed from a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Sheet |
Occurs before a worksheet is removed from a workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Sheet |
Occurs after a worksheet has been renamed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Sheet |
Occurs when a worksheet is about to be renamed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Unit |
Fires after a unit of measurement used in the workbook is changed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Unit |
Fires before a unit of measurement used within the workbook is changed. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Validate |
Allows you to validate a custom SQL query created in the Data Source Wizard. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |