Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / 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) Add custom function into the function set.  
    Public Method Add data source for template.  
    Public Method Calculates formulas in the workbook as needed.  
    Public MethodConvert the calculated barcodes to pictures and place them in their respective positions. The original barcode formulas will be cleared.
    Not support GrapeCity.Documents.Excel.Drawing.ImageType.EMF and GrapeCity.Documents.Excel.Drawing.ImageType.WMF image types.  
    Public Method Designates all the formulas of the workbook to be recalculated when the next calculation occurs.  
    Public MethodOverloaded.  Generates a workbook from a json string.  
    Public MethodOverloaded.  Generates a workbook from a JSON string containing the contents of .sjs file format.  
    Public MethodOverloaded.  Process the template and return the instance of report workbook.  
    Public Method Returns the names of the linked excel documents.  
    Public Methodstatic (Shared in Visual Basic)Overloaded. Gets all sheet names and tables names that will be used as the parameter source of ImportData.
    If the name is a table name, the worksheet name is qualified before the table name, such as "Sheet1!Table1".  
    Public Method Gets all fonts information that are used on workbook.  
    Public Methodstatic (Shared in Visual Basic)Overloaded.  Import all the data of the specified source of the file.  
    Public MethodOverloaded.  Specifies whether the file is password protected.  
    Public MethodOverloaded.  Opens the specified excel file  
    Public Method Prints the workbook.  
    Public MethodOverloaded.  Start to process the template with global options.  
    Public MethodOverloaded.  Protects a workbook so that it cannot be modified.  
    Public MethodOverloaded.  Saves data to the specified excel file.  
    Public Methodstatic (Shared in Visual Basic) Set the license key of Documents for Excel.  
    Public MethodOverloaded.  Generates a json string from a workbook.  
    Public MethodOverloaded.  Integrates all JSON files from the SpreadJS .sjs file into a single string, then put the string into the stream.  
    Public Method Removes protection from the workbook.  
    Public MethodOverloaded.  Updates a excel link.  
    Public Method Updates all the excel links.  
    Public Method Waits for all calculation to complete, includes asynchronous calculations. This method blocks the current thread until all calculations have finished. Users can call this method to ensure that all necessary computations have been performed before proceeding with any other operations that depend on the calculation results.  
    Top
    See Also