Spread WPF Documentation
Workbook Class Methods


For a list of all members of this type, see Workbook members.

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 PDF file.  
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.  
Public MethodSetCustomNameOverloaded. Adds a custom name to the name collection.  
Public MethodSuspendCalcServiceSuspends the calculation service.  
Public MethodSuspendEventSuspends the event.  
Top
See Also

Reference

Workbook Class
GrapeCity.Windows.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.