Spread.Services Documentation
IWorkbook Interface Members
Properties  Methods  Events

GrapeCity.Documents.Spread Namespace : IWorkbook Interface

The following tables list the members exposed by IWorkbook.

Public Properties
 NameDescription
 Property 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).  
 Property Determines whether to automatically parse when setting a range value to a string value.  
 Property Gets or sets CultureInfo for the workbook.  
 PropertySpecifies the table style name from the ITableStyleCollection collection that is used as the default TableStyle (read/write).  
 Property Gets or sets whether the calculation engine is valid.  
 PropertyReturns the INames collection that represents all the names in the specified workbook (including all worksheet-specific names). This is a read-only INames object.  
 PropertyReturns the IPivotCaches collection that represents all the IPivotTable caches in the specified workbook (read-only).  
 Property Gets or sets the reference style.  
 PropertyGets the ISlicerCaches object associated with the workbook.  
 PropertyReturns the IStyleCollection collection that represents all the styles in the specified workbook (read-only).  
 PropertyReturns the ITableStyleCollection collection object for the current workbook that refers to the styles used in the current workbook (read-only).  
 Property Returns the theme applied to the current workbook (read-only).  
 PropertyReturns the IWorksheets collection that represents all the worksheets in the specified workbook. This is a read-only Sheets object.  
Top
Public Methods
 NameDescription
 Method Calculates formulas of the workbook as needed.  
 Method Designates all the formulas of the workbook to be recalculated when the next calculation occurs.  
 MethodOverloaded.  Generates a workbook from a json string.  
 MethodOverloaded.  Specifies whether the file is password protected.  
 MethodOverloaded.  Opens the specified excel file  
 MethodOverloaded.  Saves data to the specified excel file.  
 MethodOverloaded.  Generates a json string from a workbook.  
Top
Public Events
 NameDescription
 Event Occurs after the workbook is saved.  
 Event Occurs before the workbook is saved.  
 Event Occurs when a new sheet is created in the workbook.  
 Event Occurs when the workbook is opened.  
 Event Occurs when a sheet is activate.  
 Event Occurs before a sheet is deleted.  
 Event Occurs when something changes in the cells of a sheet.  
 Event Occurs when a sheet is deactivated.  
 Event Occurs when the selection changes on a sheet.  
Top
See Also

Reference

IWorkbook Interface
GrapeCity.Documents.Spread Namespace