Back to Devexpress

Workbook Properties

officefileapi-devexpress-dot-spreadsheet-dot-workbook-dot-underscore-properties.md

latest15.5 KB
Original Source

Workbook Properties

A non-visual component that allows you to generate and modify spreadsheet documents.

NameDescription
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

Workbook Class

Workbook Members

DevExpress.Spreadsheet Namespace