Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / Workbook Class

In This Topic
    Workbook Class Methods
    In This Topic

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

    Public Methods
     NameDescription
    Public Methodstatic (Shared in Visual Basic)Overloaded. Add custom function into the function set.  
    Public MethodAdd data source for template  
    Public MethodCalculates formulas in the workbook as needed.  
    Public MethodForces to calculate all formulas of the workbook  
    Public MethodClears data.  
    Public MethodDesignates all the formulas of the workbook to be recalculated when the next calculation occurs.  
    Public MethodOverloaded. Generates a workbook from the json string.  
    Public MethodGets the active sheet.  
    Public MethodOccurs after the workbook is saved.  
    Public MethodGets the author.  
    Public Method  
    Public MethodDetermines whether to parse automatically when setting range value to string value.  
    Public Method  
    Public MethodOccurs before the workbook is saved.  
    Public MethodReturns an object that represents the view settings of this workbook.  
    Public MethodGets the culture info of workbook, default is Locale.getDefault().  
    Public MethodInternal use  
    Public Method  
    Public MethodSpecifies the table style that is used as the default TableStyle.  
    Public MethodSpecifies whether the calculation engine is working.  
    Public MethodFilters data in a workbook based on a cell icon from the IconSets collection.  
    Public MethodInternal use  
    Public Method  
    Public MethodReturns the INames collection that represents all the names in the specified workbook (including all worksheet-specific names).  
    Public MethodOccurs when a new sheet is created in the workbook.  
    Public MethodOccurs when the workbook is opened.  
    Public Method  
    Public MethodGets a PivotCaches collection that represents all the PivotTable caches in the specified workbook.  
    Public MethodTrue if the order of the sheets in the workbook is protected. Read-only Boolean.  
    Public MethodTrue if the windows of the workbook are protected. Read-only Boolean.  
    Public MethodGets the reference style.  
    Public Method  
    Public MethodOccurs when a sheet is active.  
    Public MethodOccurs before a sheet is deleted.  
    Public MethodOccurs when something changes in the cells of a sheet.  
    Public MethodOccurs when a sheet is deactivated.  
    Public MethodOccurs when the selection changes on a sheet.  
    Public MethodGets a collection of Signature objects that correspond to the digital signature attached to a document.  
    Public MethodGets the ISlicerCaches object associated with the workbook.  
    Public Method  
    Public MethodProvides access to the collection of cell styles in the current workbook.  
    Public MethodGets the table styles used in the current workbook.  
    Public Methodstatic (Shared in Visual Basic)Gets json serializer for custom type  
    Public MethodReturns an instance of ITheme which provides access to the theme associated with a workbook.  
    Public MethodGets all fonts information that are used on workbook.  
    Public MethodGets a collection of worksheets contained in the workbook.  
    Public MethodOverloaded. Specifies whether the file is password protected.  
    Public MethodOverloaded. Opens the file with specified file format.  
    Public MethodStart to process the template  
    Public MethodOverloaded. Protects a workbook so that it cannot be modified.  
    Public MethodOverloaded. Saves workbook to file with specified options, the option can be XlsxSaveOptions, CsvSaveOptions  
    Public MethodSets the author.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public Methodstatic (Shared in Visual Basic)Set the license key of Documents for Excel  
    Public MethodSets the reference style.  
    Public Method  
    Public Methodstatic (Shared in Visual Basic)Sets json serializer for custom type in from/to json.  
    Public Method  
    Public MethodOverloaded. Generates a json string from the workbook.  
    Public Method  
    Public MethodOverloaded. Removes protection from the workbook.  
    Top
    See Also