| Name | Description | |
|---|---|---|
  | AddCustomFunction | Overloaded. Add custom function into the function set. |
| addDataSource | Add data source for template |
| calculate | Calculates formulas in the workbook as needed. |
| calculateFull | Forces to calculate all formulas of the workbook |
| clear | Clears data. |
| createWorkbook | |
| dirty | Designates all the formulas of the workbook to be recalculated when the next calculation occurs. |
| EnsureSelectedSheetsInitialized | |
| fromJson | Overloaded. Generates a workbook from the json string. |
| getActiveSheet | Gets the active sheet. |
| getAfterSaveEvent | Occurs after the workbook is saved. |
| getAuthor | Gets the author. |
| getAutoCorrect | |
| getAutoParse | Determines whether to parse automatically when setting range value to string value. |
| getAutoRoundValue | |
| getBeforeSaveEvent | Occurs before the workbook is saved. |
| getBookView | Returns an object that represents the view settings of this workbook. |
| getCulture | Gets the culture info of workbook, default is Locale.getDefault(). |
| getCultureInfo | Internal use |
| getData | |
| getDefaultTableStyle | Specifies the table style that is used as the default TableStyle. |
| getEnableCalculation | Specifies whether the calculation engine is working. |
| getExcelLinkSources | |
| getFullName | |
| getGraphicsInfo | |
| getIconSets | Filters data in a workbook based on a cell icon from the IconSets collection. |
| getInternalHelper | Internal use |
| getMaxiumDigitWidth | |
| getName | |
| getNames | Returns the INames collection that represents all the names in the specified workbook (including all worksheet-specific names). |
| getNewSheetEvent | Occurs when a new sheet is created in the workbook. |
| getNumberFormatter | |
| getOpenedEvent | Occurs when the workbook is opened. |
| getOptions | Returns the IExcelOptions object that represents some settings to control workbook behavior. |
| getPath | |
| getPdfGraphics | |
| getPDFGraphics | |
| getPivotCaches | Gets a PivotCaches collection that represents all the PivotTable caches in the specified workbook. |
| getProtectStructure | True if the order of the sheets in the workbook is protected. Read-only Boolean. |
| getProtectWindows | True if the windows of the workbook are protected. Read-only Boolean. |
| getReferenceStyle | Gets the reference style. |
| getResetAdjacentRangeBorder | |
| getSelectedSheets | Returns a IWorksheets collection that represents all the selected sheets in the specified workbook. |
| getSheetActivateEvent | Occurs when a sheet is active. |
| getSheetBeforeDeleteEvent | Occurs before a sheet is deleted. |
| getSheetChangeEvent | Occurs when something changes in the cells of a sheet. |
| getSheetDeactivateEvent | Occurs when a sheet is deactivated. |
| getSheetSelectionChange | Occurs when the selection changes on a sheet. |
| getSignatures | Gets a collection of Signature objects that correspond to the digital signature attached to a document. |
| getSlicerCaches | Gets the ISlicerCaches object associated with the workbook. |
| GetStyle | |
| getStyles | Provides access to the collection of cell styles in the current workbook. |
| getTableStyles | Gets the table styles used in the current workbook. |
| getTagJsonSerializer | Gets json serializer for custom type |
| getTheme | Returns an instance of ITheme which provides access to the theme associated with a workbook. |
| getUsedFonts | Gets all fonts information that are used on workbook. |
| getWorksheets | Gets a collection of worksheets contained in the workbook. |
| isEncryptedFile | Overloaded. Specifies whether the file is password protected. |
| open | Overloaded. Opens the file with specified file format. |
| processTemplate | Start to process the template |
| protect | Overloaded. Protects a workbook so that it cannot be modified. |
| save | Overloaded. Saves workbook to file with specified options, the option can be XlsxSaveOptions, CsvSaveOptions |
| SelectSheets | |
| setAuthor | Sets the author. |
| setAutoParse | |
| setAutoRoundValue | |
| setCulture | |
| setDefaultTableStyle | |
| setEnableCalculation | |
| setGraphicsInfo | |
| SetLicenseKey | Set the license key of Documents for Excel |
| setName | |
| setPath | |
| setReferenceStyle | Sets the reference style. |
| setResetAdjacentRangeBorder | |
| setTagJsonSerializer | Sets json serializer for custom type in from/to json. |
| setTheme | |
| toJson | Overloaded. Generates a json string from the workbook. |
| ToRGBColor | |
| unprotect | Overloaded. Removes protection from the workbook. |
| updateExcelLink | Overloaded. |
| updateExcelLinks |