SpreadsheetML2003SaveOptions Class

SpreadsheetML2003SaveOptions class

Represents the options for saving Excel 2003 spreadml file.


type SpreadsheetML2003SaveOptions struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription
NewSpreadsheetML2003SaveOptionsCreates the options for saving Excel 2003 spreadml file.
NewSpreadsheetML2003SaveOptions_SaveOptionsConstructs from a parent object.

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
IsIndentedFormattingCauses child elements to be indented.
SetIsIndentedFormattingCauses child elements to be indented.
GetLimitAsXlsLimit as xls, the max row index is 65535 and the max column index is 255.
SetLimitAsXlsLimit as xls, the max row index is 65535 and the max column index is 255.
GetExportColumnIndexOfCellThe default value is false, it means that column index will be ignored if the cell is contiguous to the previous cell.
SetExportColumnIndexOfCellThe default value is false, it means that column index will be ignored if the cell is contiguous to the previous cell.
GetSaveFormatGets the save file format.
GetClearDataMake the workbook empty after saving the file.
SetClearDataMake the workbook empty after saving the file.
GetCachedFileFolderThe cached file folder is used to store some large data.
SetCachedFileFolderThe cached file folder is used to store some large data.
GetValidateMergedAreasIndicates whether validate merged cells before saving the file.
SetValidateMergedAreasIndicates whether validate merged cells before saving the file.
GetMergeAreasIndicates whether merge the areas of conditional formatting and validation before saving the file.
SetMergeAreasIndicates whether merge the areas of conditional formatting and validation before saving the file.
GetCreateDirectoryIf true and the directory does not exist, the directory will be automatically created before saving the file.
SetCreateDirectoryIf true and the directory does not exist, the directory will be automatically created before saving the file.
GetSortNamesIndicates whether sorting defined names before saving file.
SetSortNamesIndicates whether sorting defined names before saving file.
GetSortExternalNamesIndicates whether sorting external defined names before saving file.
SetSortExternalNamesIndicates whether sorting external defined names before saving file.
GetRefreshChartCacheIndicates whether refreshing chart cache data
SetRefreshChartCacheIndicates whether refreshing chart cache data
GetCheckExcelRestrictionWhether 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.
SetCheckExcelRestrictionWhether 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.
GetUpdateSmartArtIndicates whether updating smart art setting.The default value is false.
SetUpdateSmartArtIndicates whether updating smart art setting.The default value is false.
GetEncryptDocumentPropertiesIndicates whether encrypt document properties when saving as .xls file.The default value is true.
SetEncryptDocumentPropertiesIndicates whether encrypt document properties when saving as .xls file.The default value is true.