Name | Description | |
---|---|---|
Workbook Constructor | Creates the workbook. |
The following tables list the members exposed by Workbook.
Name | Description | |
---|---|---|
Workbook Constructor | Creates the workbook. |
Name | Description | |
---|---|---|
ActiveSheet | Gets the active sheet. | |
Author | Gets or sets the author. | |
AutoParse | Determines whether to parse automatically when setting range value to string value. | |
Culture | Gets the workbook CultureInfo. | |
DefaultTableStyle | Specifies the table style that is used as the default TableStyle. | |
EnableCalculation | Specifies whether the calculation engine is working. | |
IconSets | Filters data in a workbook based on a cell icon from the IconSets collection. This property is read-only. | |
Names | Returns the INames collection that represents all the names in the specified workbook (including all worksheet-specific names). The Names object is read-only. | |
PivotCaches | Gets a PivotCaches collection that represents all the PivotTable caches in the specified workbook. | |
ReferenceStyle | Gets or sets the reference style. | |
SlicerCaches | Gets the ISlicerCaches object associated with the workbook. | |
Styles | Provides access to the collection of cell styles in the current workbook. | |
TableStyles | Gets the table styles used in the current workbook. | |
Theme | Returns an instance of ITheme which provides access to the theme associated with a workbook. | |
Worksheets | Gets a collection of worksheets contained in the workbook. |
Name | Description | |
---|---|---|
Calculate | Calculates formulas in the workbook as needed. | |
Dirty | Designates all the formulas of the workbook to be recalculated when the next calculation occurs. | |
FromJson | Overloaded. Generates a workbook from the json string. | |
IsEncryptedFile | Overloaded. Specifies whether the file is password protected. | |
Open | Overloaded. Opens the specified excel file | |
Save | Overloaded. Saves data to the specified excel file. | |
ToJson | Overloaded. Generates a json string from the workbook. |
Name | Description | |
---|---|---|
AfterSave | Occurs after the workbook is saved. | |
BeforeSave | Occurs before the workbook is saved. | |
NewSheet | Occurs when a new sheet is created in the workbook. | |
Opened | Occurs when the workbook is opened. | |
SheetActivate | Occurs when a sheet is active. | |
SheetBeforeDelete | Occurs before a sheet is deleted. | |
SheetChange | Occurs when something changes in the cells of a sheet. | |
SheetDeactivate | Occurs when a sheet is deactivated. | |
SheetSelectionChange | Occurs when the selection changes on a sheet. |