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


The following tables list the members exposed by Workbook.

Public Constructors
 NameDescription
Public ConstructorWorkbook ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyActiveSheet Gets or sets the active sheet in the component.  
Public PropertyActiveSheetIndex Gets or sets the index of the active sheet in the component.  
Public PropertyAutoRecalculation Gets or sets a value that indicates whether to automatically recalculate.  
Public PropertyAutoRefresh Gets or sets whether the sheet can auto-refresh itself.  
Public PropertyBackgroundCalculation Gets or sets whether to calculate the formulas in the background thread to reduce the time for opening an excel file.  
Public PropertyCanCellOverflow Gets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyCurrentTheme Gets or sets the current theme for the workbook.  
Public PropertyCurrentThemeName Gets or sets the current theme information for the workbook.  
Public PropertyCustomFunctions Gets the custom functions.  
Public PropertyCustomNames Gets the custom names.  
Public PropertyGridLineColor Gets or sets the color of the gridline.  
Public PropertyHorizontalScrollBarVisibility Gets or sets the horizontal scroll bar visibility.  
Public PropertyItemOverloaded.  Gets the worksheet at the specified index.  
Public PropertyLoadExcelOnDemand Gets or sets whether to load data on demand to reduce the time for opening an excel file.  
Public PropertyName Gets or sets the name of the workbook.  
Public PropertyNamedStylesGets or sets a collection of StyleInfo objects for this sheet.  
Public PropertyProtect Gets or sets whether this workbook is protected.  
Public PropertyReferenceStyle Gets or sets the style for cell and range references in cell formulas on this sheet.  
Public PropertySheetCount Gets or sets the number of sheets for this workbook.  
Public PropertySheetsGets a collection of Worksheet objects for this workbook.  
Public PropertyShowDragDropTip Gets or sets a value that indicates whether to show the drag drop tip.  
Public PropertyShowDragFillTip Gets or sets a value that indicates whether to show the drag fill tip.  
Public PropertyShowGridLine Gets or sets a value that indicates whether to show the gridline.  
Public PropertyShowResizeTip Gets or sets whether to display a resize tip.  
Public PropertyShowScrollTip Gets or sets whether to display a scroll tip.  
Public PropertyStartSheetIndex Gets or sets the index of the start sheet of the Workbook  
Public PropertyThemes Gets themes for the workbook.  
Public PropertyVerticalScrollBarVisibility Gets or sets the vertical scroll bar visibility.  
Top
Public Methods
 NameDescription
Public MethodAddCustomFunction Adds the custom function on this sheet.  
Public MethodClearCustomFunctions Removes all user-defined custom functions (FunctionInfo object) on this sheet.  
Public MethodClearCustomName Clears the specified name on this sheet.  
Public MethodClearCustomNames Removes all custom names on this sheet.  
Public MethodClone Creates a new object that is a copy of the current instance.  
Public Methodstatic (Shared in Visual Basic)CopyTo Copies data from one range to another.  
Public MethodFindTable Gets the table with a specified name.  
Public MethodGetCustomFunction Gets the custom function based on the function name.  
Public MethodGetCustomName Gets the custom name based on the name.  
Public MethodGetThemeColor Gets the color with a specified theme name.  
Public MethodGetThemeFont Gets the font family with a specified theme name.  
Public Methodstatic (Shared in Visual Basic)MoveTo Moves data from one range to another.  
Public MethodOpenExcelAsyncOverloaded.  Opens an Excel Compound Document File and loads it into GcSpreadSheet.  
Public MethodOpenXmlOverloaded.  Loads the data on the sheet from the specified XML stream.  
Public MethodOpenXmlAsyncOverloaded.  Loads the data on the sheet from the specified XML stream asynchronously.  
Public MethodRecalculateOverloaded.  Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.  
Public MethodRemoveCustomFunctions Removes the specified custom function on this sheet.  
Public MethodReset Resets the workbook to its default settings.  
Public MethodResetThemes Reset the changed theme color and font name.  
Public MethodResumeCalcService Resumes the calculation service.  
Public MethodResumeEvent Resumes the event.  
Public MethodSaveExcelAsync Saves the control to an Excel Compound Document File stream.  
Public MethodSavePdfAsyncOverloaded.  Saves the content of the GcSpreadSheet component to the specified stream asynchronously.  
Public MethodSaveXmlOverloaded.  Saves the data on the sheet to the specified XML stream.  
Public MethodSaveXmlAsyncOverloaded.  Saves the data on the sheet to the specified XML stream asynchronously.  
Public MethodSearchOverloaded.  Searches the text in the cells in the specified sheet.  
Public MethodSetCustomNameOverloaded.  Adds a custom name to the name collection.  
Public MethodSuspendCalcService Suspends the calculation service.  
Public MethodSuspendEvent Suspends the event.  
Top
Public Events
 NameDescription
Public EventDataCalculated Occurs when all formulas are calculated.  
Public EventExcelError Occurs when an error happens while loading or saving Excel-formatted files.  
Public EventPropertyChanged Occurs when a property value changes.  
Top
See Also

Reference

Workbook Class
GrapeCity.Xaml.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options