Skip to main content
Row

IWorkbook Properties

A workbook loaded into the Spreadsheet control (for WinForms, WPF, and ASP.NET).
Name Description
ChartSheets Provides access to a collection of chart sheets contained in the workbook.
Clipboard Provides access to the object used for working with the system Clipboard. Inherited from ISpreadsheetComponent.
ColorPalette Returns a color palette for the spreadsheet document.
CreatesIntersectedBricks Inherited from IBasePrintable.
CurrentAuthor Gets the system username.
CustomFunctions Provides access to a collection of custom functions in a workbook.
CustomXmlParts Provides access to a workbook’s collection of custom XML parts.
DefinedNames Gets the collection of defined names whose scope is the current workbook.
DocumentProperties Provides access to the document properties associated with a workbook.
DocumentSettings Provides access to the settings that specify how the calculation is performed and what reference style is used.
ExternalWorkbooks Provides access to the collection of source workbooks used for creating external references in the current workbook.
FormulaEngine Provides access to a FormulaEngine object to parse or evaluate a formula.
Functions Provides access to the built-in functions in a workbook.
GlobalCustomFunctions Provides access to a collection of custom functions which are not limited in scope to the workbook in which the functions reside.
HasMacros Determines whether the workbook has VBA projects (macros).
History Provides access to the history of operations performed in a workbook.
IsDisposed Gets a value indicating whether a workbook has been disposed of.
IsProtected Gets whether the workbook is protected.
MailMergeDataMember Specifies the member of the mail merge data source.
MailMergeDataSource Specifies the data source for the mail merge.
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 document content was modified since it was last saved. Inherited from ISpreadsheetComponent.
Options Provides access to various options which can be specified for the workbook. Inherited from ISpreadsheetComponent.
Path Gets the path to the spreadsheet file loaded as an external workbook. Inherited from ExternalWorkbook.
PivotCaches Provides access to the collection of all the PivotTable caches in the specified workbook.
Range Provides access to the cell range in the worbook.
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.
Styles Provides access to the collection of cell styles in the current workbook.
TableStyles Provides access to the collection of styles to format tables and pivot tables in the workbook.
Tag Gets or sets the data associated with an IWorkbook object.
Theme Returns the theme applied to the workbook.
Unit Gets or sets a unit of measure used in the workbook. Inherited from ISpreadsheetComponent.
Worksheets Returns the collection of worksheets in a workbook.
See Also