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