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