GrapeCity.Xaml.SpreadSheet.Data
Workbook Class Members
Properties  Methods  Events


GrapeCity.Xaml.SpreadSheet.Data Namespace : Workbook Class

The following tables list the members exposed by Workbook.

Public Constructors
 NameDescription
Public ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public Property Gets or sets the active sheet in the component.  
Public Property Gets or sets the index of the active sheet in the component.  
Public Property Gets or sets a value that indicates whether to automatically recalculate.  
Public Property Gets or sets whether the sheet can auto-refresh itself.  
Public Property Gets or sets whether to calculate the formulas in the background thread to reduce the time for opening an excel file.  
Public Property Gets or sets whether data can overflow into adjacent empty cells in the component.  
Public Property Gets or sets the current theme for the workbook.  
Public Property Gets or sets the current theme information for the workbook.  
Public Property Gets the custom functions.  
Public Property Gets the custom names.  
Public Property Gets or sets the color of the gridline.  
Public Property Gets or sets the horizontal scroll bar visibility.  
Public PropertyOverloaded.  Gets the worksheet at the specified index.  
Public Property Gets or sets whether to load data on demand to reduce the time for opening an excel file.  
Public Property Gets or sets the name of the workbook.  
Public PropertyGets or sets a collection of StyleInfo objects for this sheet.  
Public Property Gets or sets whether this workbook is protected.  
Public Property Gets or sets the style for cell and range references in cell formulas on this sheet.  
Public Property Gets or sets the number of sheets for this workbook.  
Public PropertyGets a collection of Worksheet objects for this workbook.  
Public Property Gets or sets a value that indicates whether to show the drag drop tip.  
Public Property Gets or sets a value that indicates whether to show the drag fill tip.  
Public Property Gets or sets a value that indicates whether to show the gridline.  
Public Property Gets or sets whether to display a resize tip.  
Public Property Gets or sets whether to display a scroll tip.  
Public Property Gets or sets the index of the start sheet of the Workbook  
Public Property Gets themes for the workbook.  
Public Property Gets or sets the vertical scroll bar visibility.  
Top
Public Methods
 NameDescription
Public Method Adds the custom function on this sheet.  
Public Method Removes all user-defined custom functions (FunctionInfo object) on this sheet.  
Public Method Clears the specified name on this sheet.  
Public Method Removes all custom names on this sheet.  
Public Method Creates a new object that is a copy of the current instance.  
Public Methodstatic (Shared in Visual Basic) Copies data from one range to another.  
Public Method Gets the table with a specified name.  
Public Method Gets the custom function based on the function name.  
Public Method Gets the custom name based on the name.  
Public Method Gets the color with a specified theme name.  
Public Method Gets the font family with a specified theme name.  
Public Methodstatic (Shared in Visual Basic) Moves data from one range to another.  
Public MethodOverloaded.  Opens an Excel Compound Document File and loads it into GcSpreadSheet.  
Public MethodOverloaded.  Loads the data on the sheet from the specified XML stream.  
Public MethodOverloaded.  Loads the data on the sheet from the specified XML stream asynchronously.  
Public MethodOverloaded.  Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.  
Public Method Removes the specified custom function on this sheet.  
Public Method Resets the workbook to its default settings.  
Public Method Reset the changed theme color and font name.  
Public Method Resumes the calculation service.  
Public Method Resumes the event.  
Public Method Saves the control to an Excel Compound Document File stream.  
Public MethodOverloaded.  Saves the content of the GcSpreadSheet component to the specified stream asynchronously.  
Public MethodOverloaded.  Saves the data on the sheet to the specified XML stream.  
Public MethodOverloaded.  Saves the data on the sheet to the specified XML stream asynchronously.  
Public MethodOverloaded.  Searches the text in the cells in the specified sheet.  
Public MethodOverloaded.  Adds a custom name to the name collection.  
Public Method Suspends the calculation service.  
Public Method Suspends the event.  
Top
Public Events
 NameDescription
Public Event Occurs when all formulas are calculated.  
Public Event Occurs when an error happens while loading or saving Excel-formatted files.  
Public Event Occurs when a property value changes.  
Top
See Also

Reference

Workbook Class
GrapeCity.Xaml.SpreadSheet.Data Namespace