.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

Workbook Properties

A non-visual component that provides complete spreadsheet functionality. You need an active license for the DevExpress Office File API Subscription 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 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 Returns an object that contains document options. 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.
See Also