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 | [Init-only] Gets or sets culture for the workbook. The culture must contain both country/region and language. | |
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 | Provides graphics information. If this property doesn't have value, the workbook will use built-in graphic information. | |
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 | Returns the IExcelOptions object that represents some settings to control workbook behavior. | |
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. | |
ShowPivotTableFieldList | Gets or sets a value indicating whether the PivotTable field list can be shown. Default is true. | |
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 | |
WebRequestHandler | Gets or sets the singleton instance of the IWebRequestHandler implementation that will be used to handle web requests. This property provides a centralized way to access and set the web request handler for the application. | |
Worksheets | Gets a collection of worksheets contained in the workbook. | |
WriteProtection | Returns a WriteProtection object that provides access to the workbook write protection options. |