JsonSaveOptions class

JsonSaveOptions class

Represents the options of saving the workbook as a json file.

Inheritance: JsonSaveOptionsSaveOptions

The JsonSaveOptions type exposes the following members:

Constructors

ConstructorDescription
initCreates options for saving json 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.
export_hyperlink_typeRepresents the type of exporting hyperlink to json.
skip_empty_rowsIndicates whether skipping emtpy rows.
sheet_indexesRepresents the indexes of exported sheets.
schemasThe original json schema of each worksheet.
export_areaGets or sets the exporting range.
has_header_rowIndicates whether the range contains header row.
export_as_stringExports the string value of the cells to json.
indentIndicates the indent.
export_nested_structureExported as parent-child hierarchy Json structure.
export_empty_cellsIndicates whether exporting empty cells as null.
always_export_as_json_objectIndicates whether always exporting excel to json as object, even there is only a worksheet in the file.
to_excel_structIndicates whether converting to json struct of the Excel file.

See Also