Name | Description | |
---|---|---|
AddCustomFunction | Add custom function into the function set. | |
AddDataSource | Add data source for template. | |
Calculate | Calculates formulas in the workbook as needed. | |
ConvertBarcodeToPicture | Convert 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. | |
Dirty | Designates all the formulas of the workbook to be recalculated when the next calculation occurs. | |
FromJson | Overloaded. Generates a workbook from a json string. | |
FromSjsJson | Overloaded. Generates a workbook from a JSON string containing the contents of .sjs file format. | |
GenerateReport | Overloaded. Process the template and return the instance of report workbook. | |
GetExcelLinkSources | Returns the names of the linked excel documents. | |
GetNames | 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". | |
GetUsedFonts | Gets all fonts information that are used on workbook. | |
ImportData | Overloaded. Import all the data of the specified source of the file. | |
IsEncryptedFile | Overloaded. Specifies whether the file is password protected. | |
Open | Overloaded. Opens the specified excel file | |
PrintOut | Prints the workbook. | |
ProcessTemplate | Overloaded. Start to process the template with global options. | |
Protect | Overloaded. Protects a workbook so that it cannot be modified. | |
Save | Overloaded. Saves data to the specified excel file. | |
SetLicenseKey | Set the license key of Documents for Excel. | |
ToJson | Overloaded. Generates a json string from a workbook. | |
ToSjsJson | Overloaded. Integrates all JSON files from the SpreadJS .sjs file into a single string, then put the string into the stream. | |
Unprotect | Removes protection from the workbook. | |
UpdateExcelLink | Overloaded. Updates a excel link. | |
UpdateExcelLinks | Updates all the excel links. | |
WaitForCalculationToFinish | 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. |