SpreadsheetML2003SaveOptions class

SpreadsheetML2003SaveOptions class

Represents the options for saving Excel 2003 spreadml file.

Inheritance: SpreadsheetML2003SaveOptions → SaveOptions

The SpreadsheetML2003SaveOptions type exposes the following members:

Constructors

ConstructorDescription
initCreates the options for saving Excel 2003 spreadml file.
initCreates the options for saving Excel 2003 spreadml file.

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.
is_indented_formattingCauses child elements to be indented.
limit_as_xlsLimit as xls, the max row index is 65535 and the max column index is 255.
export_column_index_of_cellThe default value is false, it means that column index will be ignored if the cell is contiguous to the previous cell.

See Also

SettablePivotGlobalizationSettings class StreamProviderOptions class