Workbook Properties

A non-visual component providing complete spreadsheet functionality.

You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this class in production code.

Name	Description
ChartSheets	Provides access to a collection of chart sheets contained in the workbook. You require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
CurrentAuthor	Gets the system username. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
CustomFunctions	Provides access to a collection of custom functions in a workbook You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
CustomXmlParts	Provides access to the collection of custom XML parts in the document. You require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
DocumentProperties	Provides access to the document properties associated with a workbook. You require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
FormulaEngine	Provides access to a FormulaEngine object to parse or evaluate a formula.
Functions	Provides access to the built-in functions in a workbook. You require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
HasMacros	Determines whether the workbook has VBA projects (macros). You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
History	Provides access to the history of operations performed in a workbook. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
IsDisposed	Gets whether a workbook has been disposed of. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
IsProtected	Gets whether the workbook is protected.
IsUpdateLocked	Returns a value indicating whether the Workbook object is locked for update. You require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
MailMergeDataSource	Gets or sets the data source for the mail merge. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
MailMergeOptions	Provides access to the mail merge options.
MailMergeParameters	Provides access to a collection of parameters for queries used to obtain data in mail merge.
Model	For internal use.
Modified	Gets or sets whether the workbook content was modified since it was last saved. You require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
PivotCaches	Returns a PivotCacheCollection collection that represents all the PivotTable caches in the specified workbook. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this event in production code.
Range	Provides access to the cell range in the workbook. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
RealTimeData	Provides access to an object that is used to manually update real-time data and reconnect to data servers.
Sheets	Provides access to a collection of all sheets contained in the workbook. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
Styles	Provides access to the workbook’s collection of cell styles. You require a license to the DevExpress Office File API 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 require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
Tag	Gets or sets the data associated with a Workbook object.
Unit	Gets or sets a unit of measure used in the workbook. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.
Worksheets	Returns the collection of worksheets in a workbook. You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this property in production code.