SaveOptions

SaveOptions class

Represents all save options

Properties

NameTypeDescription
SaveFormatNumberGets the save file format. The value of the property is SaveFormat integer constant.
ClearDatabooleanMake the workbook empty after saving the file.
CachedFileFolderStringThe cached file folder is used to store some large data.
ValidateMergedAreasbooleanIndicates whether validate merged cells before saving the file. The default value is false.
MergeAreasbooleanIndicates whether merge the areas of conditional formatting and validation before saving the file. The default value is
CreateDirectorybooleanIf true and the directory does not exist, the directory will be automatically created before saving the file. The defaul
SortNamesbooleanIndicates whether sorting defined names before saving file.
SortExternalNamesbooleanIndicates whether sorting external defined names before saving file.
RefreshChartCachebooleanIndicates whether refreshing chart cache data
CheckExcelRestrictionboolean
UpdateSmartArtbooleanIndicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSm
EncryptDocumentPropertiesboolean

SaveOptions.SaveFormat property

Gets the save file format. The value of the property is SaveFormat integer constant.

Type: Number

SaveOptions.ClearData property

Make the workbook empty after saving the file.

Type: boolean

SaveOptions.CachedFileFolder property

The cached file folder is used to store some large data.

Type: String

SaveOptions.ValidateMergedAreas property

Indicates whether validate merged cells before saving the file. The default value is false.

Type: boolean

SaveOptions.MergeAreas property

Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.

Type: boolean

SaveOptions.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

SaveOptions.SortNames property

Indicates whether sorting defined names before saving file.

Type: boolean

SaveOptions.SortExternalNames property

Indicates whether sorting external defined names before saving file.

Type: boolean

SaveOptions.RefreshChartCache property

Indicates whether refreshing chart cache data

Type: boolean

SaveOptions.CheckExcelRestriction property

Type: boolean

SaveOptions.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

SaveOptions.EncryptDocumentProperties property

Type: boolean