XmlSaveOptions

XmlSaveOptions class

Represents the options of saving the workbook as an xml file.

Constructors

NameDescription
XmlSaveOptionsCreates options for saving xml file.

Properties

NameTypeDescription
SheetIndexesint[]Represents the indexes of exported sheets.
ExportAreaCellAreaGets or sets the exporting range.
HasHeaderRowbooleanIndicates whether the range contains header row.
XmlMapNameStringIndicates whether exporting xml map in the file.
SheetNameAsElementNamebooleanIndicates whether exporting sheet’s name as the name of the element.
DataAsAttributebooleanIndicates whether exporting data as attributes of element.
SaveFormatintGets 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
WarningCallbackIWarningCallbackGets or sets warning callback.
CheckExcelRestrictionboolean
UpdateSmartArtbooleanIndicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSm
EncryptDocumentPropertiesboolean

XmlSaveOptions()

Creates options for saving xml file.

XmlSaveOptions.SheetIndexes property

Represents the indexes of exported sheets.

Type: int[]

XmlSaveOptions.ExportArea property

Gets or sets the exporting range.

Type: CellArea

XmlSaveOptions.HasHeaderRow property

Indicates whether the range contains header row.

Type: boolean

XmlSaveOptions.XmlMapName property

Indicates whether exporting xml map in the file.

Type: String

XmlSaveOptions.SheetNameAsElementName property

Indicates whether exporting sheet’s name as the name of the element.

Type: boolean

XmlSaveOptions.DataAsAttribute property

Indicates whether exporting data as attributes of element.

Type: boolean

XmlSaveOptions.SaveFormat property

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

Type: int

XmlSaveOptions.ClearData property

Make the workbook empty after saving the file.

Type: boolean

XmlSaveOptions.CachedFileFolder property

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

Type: String

XmlSaveOptions.ValidateMergedAreas property

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

Type: boolean

XmlSaveOptions.MergeAreas property

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

Type: boolean

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

XmlSaveOptions.SortNames property

Indicates whether sorting defined names before saving file.

Type: boolean

XmlSaveOptions.SortExternalNames property

Indicates whether sorting external defined names before saving file.

Type: boolean

XmlSaveOptions.RefreshChartCache property

Indicates whether refreshing chart cache data

Type: boolean

XmlSaveOptions.WarningCallback property

Gets or sets warning callback.

Type: IWarningCallback

XmlSaveOptions.CheckExcelRestriction property

Type: boolean

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

XmlSaveOptions.EncryptDocumentProperties property

Type: boolean