Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / IWorkbook Interface
Methods

In This Topic
    IWorkbook Interface Members
    In This Topic

    The following tables list the members exposed by IWorkbook.

    Public Methods
     NameDescription
     MethodAdd data source for template  
     MethodCalculates formulas of the workbook as needed.  
     MethodDesignates all the formulas of the workbook to be recalculated when the next calculation occurs.  
     MethodReturns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns null if no sheet is active.  
     MethodGets whether allow dynamic array formula.This method is obsoleted, please use getFormula2() to get dynamic array formula.  
     MethodGets the author.  
     MethodGets whether to automatically parse when setting a range value to a string value.  
     MethodGets whether to round the number to 15 significant figures when getting the value.  
     MethodReturns an object that represents the view settings of this workbook.  
     MethodGets a collection that represents all the built-in document properties of the workbook.  
     MethodGets culture info for the workbook. Which influences the feature related culture.  
     MethodGets a collection that represents all the custom document properties of the workbook.  
     MethodGets the custom views of the workbook.  
     MethodGets the table style name from the ITableStyleCollection collectionthat is used as the default TableStyle.  
     MethodGets whether update the dirty state of the formula cells immediately when changing the value of a cell.  
     MethodGets whether the calculation engine is valid.  
     MethodReturns the name of the workbook, including its path on disk.  
     MethodProvides graphics information. If this property doesn't have value, the workbook will use built-in graphic information.  
     MethodFilters data in a workbook based on a cell icon from the IconSets collection.  
     MethodGets a string value that represents the name of the workbook.  
     MethodReturns the INames collection that represents all the names in thespecified workbook (including all worksheet-specific names).  
     MethodReturns the IExcelOptions object that represents some settings to control workbook behavior.  
     MethodGets a string that represents the path to the workbook file that this workbook object represents.  
     MethodReturns the IPivotCaches collection that represents all the IPivotTable caches in the specified workbook.  
     MethodTrue if the order of the sheets in the workbook is protected. Read-only Boolean.  
     MethodTrue if the windows of the workbook are protected. Read-only Boolean.  
     MethodGets the reference style.  
     MethodDetermines whether to reset adjacent range's border when setting border for a range. The default value of this property is true  
     MethodReturns a IWorksheets collection that represents all the selected sheets in the specified workbook.  
     MethodGets a collection of Signature objects that correspond to the digital signature attached to a document.  
     MethodGets the ISlicerCaches object associated with the workbook.  
     MethodReturns the IStyleCollection collection that represents all thestyles in the specified workbook.  
     MethodReturns the ITableStyleCollection collection object for the currentworkbook that refers to the styles used in the current workbook.  
     MethodReturns the theme applied to the current workbook.  
     MethodReturns the IWorksheets collection that represents all the worksheetsin the specified workbook. This is a read-only Sheets object.  
     MethodOverloaded. Specifies whether the file is password protected.  
     MethodOverloaded. Opens the specified excel file  
     MethodStart to process the template  
     MethodOverloaded. Protects a workbook so that it cannot be modified.  
     MethodOverloaded. Saves the workbook to the disk.  
     MethodSets whether allow dynamic array formula.This method is obsoleted, please use setFormula2() to set dynamic array formula.  
     MethodSets the author.  
     MethodSets whether to automatically parse when setting a range value to a string value.  
     MethodSets whether to round the number to 15 significant figures when getting the value.  
     MethodSets culture info for the workbook. Which influences the feature related culture.  
     MethodSets the table style name from the ITableStyleCollection collectionthat is used as the default TableStyle.  
     MethodSets whether update the dirty state of the formula cells immediately when changing the value of a cell.  
     MethodSets whether the calculation engine is valid.  
     MethodProvides graphics information. If this property doesn't have value, the workbook will use built-in graphic information.  
     MethodSets a string value that represents the name of the workbook.  
     MethodSets a string that represents the path to the workbook file that this workbook object represents.  
     MethodSets the reference style.  
     MethodDetermines whether to reset adjacent range's border when setting border for a range. The default value of this property is true  
     MethodSets the theme applied to the current workbook.  
     MethodOverloaded. Generates a json string from a workbook.  
     MethodOverloaded. Removes protection from the workbook.  
     MethodOverloaded. Updates a excel link.  
     MethodUpdates all the excel links.  
    Top
    See Also