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 |