IWorkbook Interface Members

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

GrapeCity.Documents.Spread Namespace : IWorkbook Interface

The following tables list the members exposed by IWorkbook.

Public Properties

| Name | Description
--- | --- | ---
| ActiveSheet | Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns null if no sheet is active (read-only).
| AutoParse | Determines whether to automatically parse when setting a range value to a string value.
| Culture | Gets or sets CultureInfo for the workbook.
| DefaultTableStyle | Specifies the table style name from the ITableStyleCollection collection that is used as the default TableStyle (read/write).
| EnableCalculation | Gets or sets whether the calculation engine is valid.
| Names | Returns the INames collection that represents all the names in the specified workbook (including all worksheet-specific names). This is a read-only INames object.
| PivotCaches | Returns the IPivotCaches collection that represents all the IPivotTable caches in the specified workbook (read-only).
| ReferenceStyle | Gets or sets the reference style.
| SlicerCaches | Gets the ISlicerCaches object associated with the workbook.
| Styles | Returns the IStyleCollection collection that represents all the styles in the specified workbook (read-only).
| TableStyles | Returns the ITableStyleCollection collection object for the current workbook that refers to the styles used in the current workbook (read-only).
| Theme | Returns the theme applied to the current workbook (read-only).
| Worksheets | Returns the IWorksheets collection that represents all the worksheets in the specified workbook. This is a read-only Sheets object.

Top
Public Methods

| Name | Description
--- | --- | ---
| Calculate | Calculates formulas of 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 a 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 a 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 activate.
| 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

IWorkbook Interface
GrapeCity.Documents.Spread Namespace

Copyright © GrapeCity, inc. All rights reserved.

Send Feedback