Workbook Properties
A non-visual component that allows you to generate and modify spreadsheet documents.Name | Description |
---|---|
ChartSheets |
Provides access to a collection of chart sheets contained in the workbook. You need an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
CurrentAuthor |
Gets the system username. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
CustomFunctions |
Provides access to a collection of custom functions in a workbook You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
CustomXmlParts |
Provides access to a workbook’s collection of custom XML parts. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
DefinedNames |
Gets the collection of defined names whose scope is the current workbook. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
DocumentProperties |
Provides access to the document properties associated with a workbook. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
DocumentSettings |
Provides access to the settings that specify how the calculation is performed and what reference style is used. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
ExternalWorkbooks |
Provides access to the collection of source workbooks used for creating external references in the current workbook. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
FormulaEngine |
Provides access to an object used to parse and evaluate formulas. You need an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
GlobalCustomFunctions |
Provides access to a collection of custom functions which are not limited in scope to the workbook in which the functions reside. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
HasMacros |
Determines whether the workbook has VBA projects (macros). You need an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
IsDisposed |
Indicates whether a workbook has been disposed of. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
IsProtected |
Indicates whether a workbook is protected. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
IsUpdateLocked |
Returns a value indicating whether the Workbook object is locked for update. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
MailMergeDataMember |
Gets or sets a specific data member in a data source that contains several tables or members. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
MailMergeDataSource |
Gets or sets the data source for the mail merge. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
MailMergeOptions |
Provides access to mail merge options. You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
MailMergeParameters |
Provides access to a collection of query parameters used to obtain data in mail merge. You need an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
Options |
Provides access to the variety of options which can be specified for the workbook. You need an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
PivotCaches |
Returns the collection of all PivotTable caches in a workbook. You need an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
RealTimeData |
Returns an object used to manually update real-time data and reconnect to data servers. You need an active 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 an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |
TableStyles |
Provides access to the collection of styles to format tables in the workbook. You need an active 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 an active 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 an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code. |