XlsbSaveOptions
XlsbSaveOptions class
Represents the options for saving xlsb file.
class XlsbSaveOptions extends SaveOptions;
Constructors
Name | Description |
---|---|
constructor() | Creates xlsb file save options. |
constructor(SaveOptions) | Constructs from a parent object convertible to this. |
Methods
Method | Description |
---|---|
getCompressionType() | Gets and sets the compression type for ooxml file. |
setCompressionType(OoxmlCompressionType) | Gets and sets the compression type for ooxml file. |
getExportAllColumnIndexes() | Indicates whether exporting all column indexes for cells. |
setExportAllColumnIndexes(boolean) | Indicates whether exporting all column indexes for cells. |
getLightCellsDataProvider() | The data provider for saving workbook in light mode. |
setLightCellsDataProvider(LightCellsDataProvider) | The data provider for saving workbook in light mode. |
getSaveFormat() | Gets the save file format. |
getClearData() | Make the workbook empty after saving the file. |
setClearData(boolean) | Make the workbook empty after saving the file. |
getCachedFileFolder() | The cached file folder is used to store some large data. |
setCachedFileFolder(string) | The cached file folder is used to store some large data. |
getValidateMergedAreas() | Indicates whether validate merged cells before saving the file. |
setValidateMergedAreas(boolean) | Indicates whether validate merged cells before saving the file. |
getMergeAreas() | Indicates whether merge the areas of conditional formatting and validation before saving the file. |
setMergeAreas(boolean) | Indicates whether merge the areas of conditional formatting and validation before saving the file. |
getCreateDirectory() | If true and the directory does not exist, the directory will be automatically created before saving the file. |
setCreateDirectory(boolean) | If true and the directory does not exist, the directory will be automatically created before saving the file. |
getSortNames() | Indicates whether sorting defined names before saving file. |
setSortNames(boolean) | Indicates whether sorting defined names before saving file. |
getSortExternalNames() | Indicates whether sorting external defined names before saving file. |
setSortExternalNames(boolean) | Indicates whether sorting external defined names before saving file. |
getRefreshChartCache() | Indicates whether refreshing chart cache data |
setRefreshChartCache(boolean) | Indicates whether refreshing chart cache data |
setWarningCallback(IWarningCallback) | Gets or sets warning callback. |
getWarningCallback() | Gets or sets warning callback. |
getUpdateSmartArt() | Indicates whether updating smart art setting. The default value is false. |
setUpdateSmartArt(boolean) | Indicates whether updating smart art setting. The default value is false. |
constructor()
Creates xlsb file save options.
constructor();
constructor(SaveOptions)
Constructs from a parent object convertible to this.
constructor(obj: SaveOptions);
Parameters:
Parameter | Type | Description |
---|---|---|
obj | SaveOptions | The parent object. |
getCompressionType()
Gets and sets the compression type for ooxml file.
getCompressionType() : OoxmlCompressionType;
Returns
Remarks
The default value is OoxmlCompressionType.Level6.
setCompressionType(OoxmlCompressionType)
Gets and sets the compression type for ooxml file.
setCompressionType(value: OoxmlCompressionType) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | OoxmlCompressionType | The value to set. |
Remarks
The default value is OoxmlCompressionType.Level6.
getExportAllColumnIndexes()
Indicates whether exporting all column indexes for cells.
getExportAllColumnIndexes() : boolean;
Remarks
The default value is true.
setExportAllColumnIndexes(boolean)
Indicates whether exporting all column indexes for cells.
setExportAllColumnIndexes(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
Remarks
The default value is true.
getLightCellsDataProvider()
The data provider for saving workbook in light mode.
getLightCellsDataProvider() : LightCellsDataProvider;
Returns
setLightCellsDataProvider(LightCellsDataProvider)
The data provider for saving workbook in light mode.
setLightCellsDataProvider(value: LightCellsDataProvider) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | LightCellsDataProvider | The value to set. |
getSaveFormat()
Gets the save file format.
getSaveFormat() : SaveFormat;
Returns
getClearData()
Make the workbook empty after saving the file.
getClearData() : boolean;
setClearData(boolean)
Make the workbook empty after saving the file.
setClearData(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
getCachedFileFolder()
The cached file folder is used to store some large data.
getCachedFileFolder() : string;
setCachedFileFolder(string)
The cached file folder is used to store some large data.
setCachedFileFolder(value: string) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | string | The value to set. |
getValidateMergedAreas()
Indicates whether validate merged cells before saving the file.
getValidateMergedAreas() : boolean;
Remarks
The default value is false.
setValidateMergedAreas(boolean)
Indicates whether validate merged cells before saving the file.
setValidateMergedAreas(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
Remarks
The default value is false.
getMergeAreas()
Indicates whether merge the areas of conditional formatting and validation before saving the file.
getMergeAreas() : boolean;
Remarks
The default value is false.
setMergeAreas(boolean)
Indicates whether merge the areas of conditional formatting and validation before saving the file.
setMergeAreas(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
Remarks
The default value is false.
getCreateDirectory()
If true and the directory does not exist, the directory will be automatically created before saving the file.
getCreateDirectory() : boolean;
Remarks
The default value is false.
setCreateDirectory(boolean)
If true and the directory does not exist, the directory will be automatically created before saving the file.
setCreateDirectory(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
Remarks
The default value is false.
getSortNames()
Indicates whether sorting defined names before saving file.
getSortNames() : boolean;
setSortNames(boolean)
Indicates whether sorting defined names before saving file.
setSortNames(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
getSortExternalNames()
Indicates whether sorting external defined names before saving file.
getSortExternalNames() : boolean;
setSortExternalNames(boolean)
Indicates whether sorting external defined names before saving file.
setSortExternalNames(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
getRefreshChartCache()
Indicates whether refreshing chart cache data
getRefreshChartCache() : boolean;
setRefreshChartCache(boolean)
Indicates whether refreshing chart cache data
setRefreshChartCache(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
setWarningCallback(IWarningCallback)
Gets or sets warning callback.
setWarningCallback(value: IWarningCallback) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | IWarningCallback | The value to set. |
getWarningCallback()
Gets or sets warning callback.
getWarningCallback() : IWarningCallback;
Returns
getUpdateSmartArt()
Indicates whether updating smart art setting. The default value is false.
getUpdateSmartArt() : boolean;
Remarks
Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.
setUpdateSmartArt(boolean)
Indicates whether updating smart art setting. The default value is false.
setUpdateSmartArt(value: boolean) : void;
Parameters:
Parameter | Type | Description |
---|---|---|
value | boolean | The value to set. |
Remarks
Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.