Name | Description | |
---|---|---|
![]() | Workbook Constructor | Overloaded. |
The following tables list the members exposed by Workbook.
Name | Description | |
---|---|---|
![]() | Workbook Constructor | Overloaded. |
Name | Description | |
---|---|---|
![]() | ActiveSheet | Gets the active sheet. |
![]() | AllowDynamicArray | This api is obsolete, please use Formula2 to get or set dynamic array formula. |
![]() | Author | Gets or sets the author. |
![]() | AutoParse | Determines whether to parse automatically when setting range value to string value. |
![]() | AutoRoundValue | Determines whether to round the number to 15 significant figures when getting the value. |
![]() | BookView | Returns an object that represents the view settings of this workbook(read-only). |
![]() | BuiltInDocumentProperties | Gets a collection that represents all the built-in document properties of the workbook. |
![]() | Culture | Gets the workbook CultureInfo. |
![]() | CustomDocumentProperties | Gets a collection that represents all the custom document properties of the workbook. |
![]() | CustomViews | Gets the custom views of the workbook. |
![]() | DefaultTableStyle | Specifies the table style that is used as the default TableStyle. |
![]() | DeferUpdateDirtyState | Gets or sets whether update the dirty state of the formula cells immediately when changing the value of a cell. |
![]() | EnableCalculation | Specifies whether the calculation engine is working. |
![]() ![]() | FontsFolderPath | Gets or sets the location of font files that will be used when exporting pdf. |
![]() | FullName | Returns the name of the workbook, including its path on disk. |
![]() | GraphicsInfo | |
![]() | IconSets | Filters data in a workbook based on a cell icon from the IconSets collection. This property is read-only. |
![]() ![]() | LoggerFactory | Gets or sets the logger factory shared by all workbooks. |
![]() | Name | Get or set a string value that represents the name of the workbook. |
![]() | Names | Returns the INames collection that represents the workbook-specified names. The Names object is read-only. |
![]() | Options | |
![]() | Path | Gets or sets a string that represents the path to the workbook file that this workbook object represents. |
![]() | PivotCaches | Gets a PivotCaches collection that represents all the PivotTable caches in the specified workbook. |
![]() | ProtectStructure | True if the order of the sheets in the workbook is protected. Read-only Boolean |
![]() | ProtectWindows | True if the windows of the workbook are protected. Read-only Boolean. |
![]() | ReferenceStyle | Gets or sets the reference style. |
![]() | ResetAdjacentRangeBorder | Determines whether to reset adjacent range's border when setting border for a range. The default value of this property is true |
![]() | SelectedSheets | Returns a IWorksheets collection that represents all the selected sheets in the specified workbook. |
![]() | Signatures | Gets a collection of Signature objects that correspond to the digital signature attached to a document. |
![]() | SlicerCaches | Gets the ISlicerCaches object associated with the workbook. |
![]() | Styles | Provides access to the collection of cell styles in the current workbook. |
![]() | TableStyles | Gets the table styles used in the current workbook. |
![]() ![]() | TagJsonSerializer | Gets or sets the json serializer/deserializer for custom type |
![]() | Theme | Returns an instance of ITheme which provides access to the theme associated with a workbook. |
![]() ![]() | ValueJsonSerializer | Gets or sets the json serializer/deserializer for custom cell values |
![]() | Worksheets | Gets a collection of worksheets contained in the workbook. |
![]() | WriteProtection | Returns a WriteProtection object that provides access to the workbook write protection options. |
Name | Description | |
---|---|---|
![]() ![]() | AddCustomFunction | Add custom function into the function set. |
![]() | AddDataSource | Add data source for template |
![]() | Calculate | Calculates formulas in the workbook as needed. |
![]() | 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. |
![]() | 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 | 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. |
Name | Description | |
---|---|---|
![]() | AfterSave | Occurs after the workbook is saved. |
![]() | BeforeSave | Occurs before the workbook is saved. |
![]() | NewSheet | Occurs when a new sheet is created in the workbook. |
![]() | Opened | Occurs when the workbook is opened. |
![]() | SheetActivate | Occurs when a sheet is active. |
![]() | SheetBeforeDelete | Occurs before a sheet is deleted. |
![]() | SheetChange | Occurs when something changes in the cells of a sheet. |
![]() | SheetDeactivate | Occurs when a sheet is deactivated. |
![]() | SheetSelectionChange | Occurs when the selection changes on a sheet. |