Spread WPF 15
GrapeCity.Windows.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 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 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.  
    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 © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page