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 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.
ColorPalette	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.
CurrentAuthor	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.
CustomFunctions	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.
CustomXmlParts	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.
DefinedNames	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.
DocumentProperties	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.
DocumentSettings	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.
ExternalWorkbooks	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.
FormulaEngine	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.
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 a 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 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.
IsDisposed	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.
IsProtected	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.
IsUpdateLocked	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.
MailMergeDataMember	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.
MailMergeDataSource	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.
MailMergeOptions	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.
MailMergeParameters	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.
PivotCaches	Returns the collection of all PivotTable caches 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.
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.
RealTimeData	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.
TableStyles	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.