XlsbSaveOptions class

XlsbSaveOptions class

Represents the options for saving xlsb file.

Inheritance: XlsbSaveOptionsSaveOptions

The XlsbSaveOptions type exposes the following members:

Constructors

ConstructorDescription
__init__(self)Creates xlsb file save options.
__init__(self, save_format)Creates xlsb file save options.

Properties

PropertyDescription
save_formatGets the save file format.
clear_dataMake the workbook empty after saving the file.
cached_file_folderThe cached file folder is used to store some large data.
validate_merged_areasIndicates whether validate merged cells before saving the file.
merge_areasIndicates whether merge the areas of conditional formatting and validation before saving the file.
create_directoryIf true and the directory does not exist, the directory will be automatically created before saving the file.
sort_namesIndicates whether sorting defined names before saving file.
sort_external_namesIndicates whether sorting external defined names before saving file.
refresh_chart_cacheIndicates whether refreshing chart cache data
warning_callbackGets or sets warning callback.
check_excel_restrictionWhether check restriction of excel file when user modify cells related objects.
For example, excel does not allow inputting string value longer than 32K.
When you input a value longer than 32K, it will be truncated.
update_smart_artIndicates whether updating smart art setting.
The default value is false.
encrypt_document_propertiesIndicates whether encrypt document properties when saving as .xls file.
The default value is true.
compression_typeGets and sets the compression type for ooxml file.
export_all_column_indexesIndicates whether exporting all column indexes for cells.
light_cells_data_providerThe data provider for saving workbook in light mode.

See Also