Skip to main content
Row

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.

See Also