Workbook Class Members

Spread.Services Documentation
Workbook Class Members
Properties Methods Events Collapse All Expand All Members Options: Show All Members Options: Filtered
Include Inherited Members

GrapeCity.Documents.Spread Namespace : Workbook Class

The following tables list the members exposed by Workbook.

Public Constructors

| Name | Description
--- | --- | ---
| Workbook Constructor | Creates the workbook.

Top
Public Properties

| 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.

Top
Public Methods

| 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.

Top
Public Events

| 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.

Top
See Also

#### Reference

Workbook Class
GrapeCity.Documents.Spread Namespace

Copyright © GrapeCity, inc. All rights reserved.

Send Feedback