Spread.Services Documentation
Workbook Class Members
Properties  Methods  Events

GrapeCity.Documents.Spread Namespace : Workbook Class

The following tables list the members exposed by Workbook.

Public Constructors
 NameDescription
Public Constructor Creates the workbook.  
Top
Public Properties
 NameDescription
Public Property Gets the active sheet.  
Public Property Gets or sets the author.  
Public Property Determines whether to parse automatically when setting range value to string value.  
Public Property Gets the workbook CultureInfo.  
Public Property Specifies the table style that is used as the default TableStyle.  
Public Property Specifies whether the calculation engine is working.  
Public Property Filters data in a workbook based on a cell icon from the IconSets collection. This property is read-only.  
Public PropertyReturns the INames collection that represents all the names in the specified workbook (including all worksheet-specific names). The Names object is read-only.  
Public Property Gets a PivotCaches collection that represents all the PivotTable caches in the specified workbook.  
Public Property Gets or sets the reference style.  
Public PropertyGets the ISlicerCaches object associated with the workbook.  
Public Property Provides access to the collection of cell styles in the current workbook.  
Public Property Gets the table styles used in the current workbook.  
Public Property Returns an instance of ITheme which provides access to the theme associated with a workbook.  
Public Property Gets a collection of worksheets contained in the workbook.  
Top
Public Methods
 NameDescription
Public Method Calculates formulas in the workbook as needed.  
Public Method Designates all the formulas of the workbook to be recalculated when the next calculation occurs.  
Public MethodOverloaded.  Generates a workbook from the json string.  
Public MethodOverloaded.  Specifies whether the file is password protected.  
Public MethodOverloaded.  Opens the specified excel file  
Public MethodOverloaded.  Saves data to the specified excel file.  
Public MethodOverloaded.  Generates a json string from the workbook.  
Top
Public Events
 NameDescription
Public Event Occurs after the workbook is saved.  
Public Event Occurs before the workbook is saved.  
Public Event Occurs when a new sheet is created in the workbook.  
Public Event Occurs when the workbook is opened.  
Public Event Occurs when a sheet is active.  
Public Event Occurs before a sheet is deleted.  
Public Event Occurs when something changes in the cells of a sheet.  
Public Event Occurs when a sheet is deactivated.  
Public Event Occurs when the selection changes on a sheet.  
Top
See Also

Reference

Workbook Class
GrapeCity.Documents.Spread Namespace