IWorkbook Properties
A workbook loaded into the Spreadsheet control (for WinForms, WPF, and ASP.NET).Name | Description |
---|---|
Chart |
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 ISpreadsheet |
Color |
Returns a color palette for the spreadsheet document. |
Creates |
Inherited from IBase |
Current |
Gets the system username. |
Custom |
Provides access to a collection of custom functions in a workbook. |
Custom |
Provides access to a workbook’s collection of custom XML parts. |
Defined |
Gets the collection of defined names whose scope is the current workbook. |
Document |
Provides access to the document properties associated with a workbook. |
Document |
Provides access to the settings that specify how the calculation is performed and what reference style is used. |
External |
Provides access to the collection of source workbooks used for creating external references in the current workbook. |
Formula |
Provides access to a Formula |
Functions | Provides access to the built-in functions in a workbook. |
Global |
Provides access to a collection of custom functions which are not limited in scope to the workbook in which the functions reside. |
Has |
Determines whether the workbook has VBA projects (macros). |
History | Provides access to the history of operations performed in a workbook. |
Is |
Gets a value indicating whether a workbook has been disposed of. |
Is |
Gets whether the workbook is protected. |
Mail |
Specifies the member of the mail merge data source. |
Mail |
Specifies the data source for the mail merge. |
Mail |
Provides access to the mail merge options. |
Mail |
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 ISpreadsheet |
Options |
Provides access to various options which can be specified for the workbook.
Inherited from ISpreadsheet |
Path |
Gets the path to the spreadsheet file loaded as an external workbook.
Inherited from External |
Pivot |
Provides access to the collection of all the Pivot |
Range | Provides access to the cell range in the worbook. |
Real |
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. |
Table |
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 ISpreadsheet |
Worksheets | Returns the collection of worksheets in a workbook. |
See Also