Spread Silverlight Documentation
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 PropertyActiveSheetGets or sets the active sheet in the component.  
Public PropertyActiveSheetIndexGets or sets the index of the active sheet in the component.  
Public PropertyAutoRecalculationGets or sets a value that indicates whether to automatically recalculate.  
Public PropertyAutoRefreshGets or sets whether the sheet can auto-refresh itself.  
Public PropertyBackgroundCalculationGets or sets whether to calculate the formulas in the background thread to reduce the time for opening an excel file.  
Public PropertyCanCellOverflowGets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyCurrentThemeGets or sets the current theme for the workbook.  
Public PropertyCurrentThemeNameGets or sets the current theme information for the workbook.  
Public PropertyCustomFunctionsGets the custom functions.  
Public PropertyCustomNamesGets the custom names.  
Public PropertyGridLineColorGets or sets the color of the gridline.  
Public PropertyHorizontalScrollBarVisibilityGets or sets the horizontal scroll bar visibility.  
Public PropertyItemOverloaded. Gets the worksheet at the specified index.  
Public PropertyLoadExcelOnDemandGets or sets whether to load data on demand to reduce the time for opening an excel file.  
Public PropertyNameGets or sets the name of the workbook.  
Public PropertyNamedStylesGets or sets a collection of StyleInfo objects for this sheet.  
Public PropertyProtectGets or sets whether this workbook is protected.  
Public PropertyReferenceStyleGets or sets the style for cell and range references in cell formulas on this sheet.  
Public PropertySheetCountGets or sets the number of sheets for this workbook.  
Public PropertySheetsGets a collection of Worksheet objects for this workbook.  
Public PropertyShowDragDropTipGets or sets a value that indicates whether to show the drag drop tip.  
Public PropertyShowDragFillTipGets or sets a value that indicates whether to show the drag fill tip.  
Public PropertyShowGridLineGets or sets a value that indicates whether to show the gridline.  
Public PropertyShowResizeTipGets or sets whether to display a resize tip.  
Public PropertyShowScrollTipGets or sets whether to display a scroll tip.  
Public PropertyStartSheetIndexGets or sets the index of the start sheet of the Workbook  
Public PropertyThemesGets themes for the workbook.  
Public PropertyVerticalScrollBarVisibilityGets or sets the vertical scroll bar visibility.  
Top
Public Methods
 NameDescription
Public MethodAddCustomFunctionAdds the custom function on this sheet.  
Public MethodClearCustomFunctionsRemoves all user-defined custom functions (FunctionInfo object) on this sheet.  
Public MethodClearCustomNameClears the specified name on this sheet.  
Public MethodClearCustomNamesRemoves all custom names on this sheet.  
Public MethodCloneCreates a new object that is a copy of the current instance.  
Public Methodstatic (Shared in Visual Basic)CopyToCopies data from one range to another.  
Public MethodFindTableGets the table with a specified name.  
Public MethodGetCustomFunctionGets the custom function based on the function name.  
Public MethodGetCustomNameGets the custom name based on the name.  
Public MethodGetThemeColorGets the color with a specified theme name.  
Public MethodGetThemeFontGets the font family with a specified theme name.  
Public Methodstatic (Shared in Visual Basic)MoveToMoves data from one range to another.  
Public MethodOpenExcelOverloaded. 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 MethodRecalculateOverloaded. Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.  
Public MethodRemoveCustomFunctionsRemoves the specified custom function on this sheet.  
Public MethodResetResets the workbook to its default settings.  
Public MethodResetThemesReset the changed theme color and font name.  
Public MethodResumeCalcServiceResumes the calculation service.  
Public MethodResumeEventResumes the event.  
Public MethodSaveExcelSaves the control to an Excel Compound Document File stream.  
Public MethodSavePdfOverloaded. Saves the content of the GcSpreadSheet component to the specified stream.  
Public MethodSaveXmlOverloaded. Saves the data on the sheet to the specified XML stream.  
Public MethodSearchOverloaded. Searches the text in the cells in the specified sheet for the specified string with the specified criteria and start and end location, and whether to search notes and tags as well.  
Public MethodSetCustomNameOverloaded. Adds a custom name to the name collection.  
Public MethodSuspendCalcServiceSuspends the calculation service.  
Public MethodSuspendEventSuspends the event.  
Top
Public Events
 NameDescription
Public EventDataCalculatedOccurs when all formulas are calculated.  
Public EventExcelErrorOccurs when an error happens while loading or saving Excel-formatted files.  
Public EventPropertyChangedOccurs when a property value changes.  
Top
See Also

Reference

Workbook Class
GrapeCity.Windows.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.