Spread WPF Documentation
Workbook Class Members
Properties  Methods  Events


GrapeCity.Windows.SpreadSheet.Data Namespace : Workbook Class

The following tables list the members exposed by Workbook.

Public Constructors
 NameDescription
Public ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyGets or sets the active sheet in the component.  
Public PropertyGets or sets the index of the active sheet in the component.  
Public PropertyGets or sets a value that indicates whether to automatically recalculate.  
Public PropertyGets or sets whether the sheet can auto-refresh itself.  
Public PropertyGets or sets whether to calculate the formulas in the background thread to reduce the time for opening an excel file.  
Public PropertyGets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyGets or sets the current theme for the workbook.  
Public PropertyGets or sets the current theme information for the workbook.  
Public PropertyGets the custom functions.  
Public PropertyGets the custom names.  
Public PropertyGets or sets the color of the gridline.  
Public PropertyGets or sets the horizontal scroll bar visibility.  
Public PropertyOverloaded. Gets the worksheet at the specified index.  
Public PropertyGets or sets whether to load data on demand to reduce the time for opening an excel file.  
Public PropertyGets or sets the name of the workbook.  
Public PropertyGets or sets a collection of StyleInfo objects for this sheet.  
Public PropertyGets or sets whether this workbook is protected.  
Public PropertyGets or sets the style for cell and range references in cell formulas on this sheet.  
Public PropertyGets or sets the number of sheets for this workbook.  
Public PropertyGets a collection of Worksheet objects for this workbook.  
Public PropertyGets or sets a value that indicates whether to show the drag drop tip.  
Public PropertyGets or sets a value that indicates whether to show the drag fill tip.  
Public PropertyGets or sets a value that indicates whether to show the gridline.  
Public PropertyGets or sets whether to display a resize tip.  
Public PropertyGets or sets whether to display a scroll tip.  
Public PropertyGets or sets the index of the start sheet of the Workbook  
Public PropertyGets themes for the workbook.  
Public PropertyGets or sets the vertical scroll bar visibility.  
Top
Public Methods
 NameDescription
Public MethodAdds the custom function on this sheet.  
Public MethodRemoves all user-defined custom functions (FunctionInfo object) on this sheet.  
Public MethodClears the specified name on this sheet.  
Public MethodRemoves all custom names on this sheet.  
Public MethodCreates 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 MethodGets the table with a specified name.  
Public MethodGets the custom function based on the function name.  
Public MethodGets the custom name based on the name.  
Public MethodGets the color with a specified theme name.  
Public MethodGets 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. Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.  
Public MethodRemoves the specified custom function on this sheet.  
Public MethodResets the workbook to its default settings.  
Public MethodReset the changed theme color and font name.  
Public MethodResumes the calculation service.  
Public MethodResumes the event.  
Public MethodSaves the control to an Excel Compound Document File stream.  
Public MethodOverloaded. Saves the content of the GcSpreadSheet component to the specified PDF file.  
Public MethodOverloaded. Saves the data on the sheet to the specified XML stream.  
Public MethodOverloaded. Searches the text in the cells in the specified sheet.  
Public MethodOverloaded. Adds a custom name to the name collection.  
Public MethodSuspends the calculation service.  
Public MethodSuspends the event.  
Top
Public Events
 NameDescription
Public EventOccurs when all formulas are calculated.  
Public EventOccurs when an error happens while loading or saving Excel-formatted files.  
Public EventOccurs when a property value changes.  
Top
See Also

Reference

Workbook Class
GrapeCity.Windows.SpreadSheet.Data Namespace