XlsbSaveOptions
XlsbSaveOptions class
Represents the options for saving xlsb file.
Constructors
| Name | Description |
|---|---|
| XlsbSaveOptions | Creates xlsb file save options. |
| XlsbSaveOptions | Creates xlsb file save options. NOTE: This constructor is now obsolete. Instead, please use XlsbSaveOptions() constructo |
Properties
| Name | Type | Description |
|---|---|---|
| CompressionType | int | Gets and sets the compression type for ooxml file. The value of the property is OoxmlCompressionType integer constant. T |
| ExportAllColumnIndexes | boolean | Indicates whether exporting all column indexes for cells. The default value is true. |
| LightCellsDataProvider | LightCellsDataProvider | The data provider for saving workbook in light mode. |
| SaveFormat | int | Gets the save file format. The value of the property is SaveFormat integer constant. |
| ClearData | boolean | Make the workbook empty after saving the file. |
| CachedFileFolder | String | The cached file folder is used to store some large data. |
| ValidateMergedAreas | boolean | Indicates whether validate merged cells before saving the file. The default value is false. |
| MergeAreas | boolean | Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is |
| CreateDirectory | boolean | If true and the directory does not exist, the directory will be automatically created before saving the file. The defaul |
| SortNames | boolean | Indicates whether sorting defined names before saving file. |
| SortExternalNames | boolean | Indicates whether sorting external defined names before saving file. |
| RefreshChartCache | boolean | Indicates whether refreshing chart cache data |
| CheckExcelRestriction | boolean | |
| UpdateSmartArt | boolean | Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSm |
| EncryptDocumentProperties | boolean |
XlsbSaveOptions() (1 of 2)
Creates xlsb file save options.
XlsbSaveOptions(saveFormat) (2 of 2)
Creates xlsb file save options. NOTE: This constructor is now obsolete. Instead, please use XlsbSaveOptions() constructor. This property will be removed 12 months later since January 2021. Aspose apologizes for any inconvenience you may have experienced.
| Parameter | Type | Description |
|---|---|---|
| saveFormat | int | A SaveFormat value. The save format . It must be xlsb. |
XlsbSaveOptions.CompressionType property
Gets and sets the compression type for ooxml file. The value of the property is OoxmlCompressionType integer constant. The default value is OoxmlCompressionType.Level6.
Type: int
XlsbSaveOptions.ExportAllColumnIndexes property
Indicates whether exporting all column indexes for cells. The default value is true.
Type: boolean
XlsbSaveOptions.LightCellsDataProvider property
The data provider for saving workbook in light mode.
Type: LightCellsDataProvider
XlsbSaveOptions.SaveFormat property
Gets the save file format. The value of the property is SaveFormat integer constant.
Type: int
XlsbSaveOptions.ClearData property
Make the workbook empty after saving the file.
Type: boolean
XlsbSaveOptions.CachedFileFolder property
The cached file folder is used to store some large data.
Type: String
XlsbSaveOptions.ValidateMergedAreas property
Indicates whether validate merged cells before saving the file. The default value is false.
Type: boolean
XlsbSaveOptions.MergeAreas property
Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.
Type: boolean
XlsbSaveOptions.CreateDirectory property
If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.
Type: boolean
XlsbSaveOptions.SortNames property
Indicates whether sorting defined names before saving file.
Type: boolean
XlsbSaveOptions.SortExternalNames property
Indicates whether sorting external defined names before saving file.
Type: boolean
XlsbSaveOptions.RefreshChartCache property
Indicates whether refreshing chart cache data
Type: boolean
XlsbSaveOptions.CheckExcelRestriction property
Type: boolean
XlsbSaveOptions.UpdateSmartArt property
Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.
Type: boolean
XlsbSaveOptions.EncryptDocumentProperties property
Type: boolean