Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / Workbook Class
Properties Methods Events

In This Topic
    Workbook Class Members
    In This Topic

    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. 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 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 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 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