XmlLoadOptions Class

XmlLoadOptions class

Represents the options of loading xml.

type XmlLoadOptions struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description
NewXmlLoadOptions	Represents the options of loading xml file.
NewXmlLoadOptions_LoadFormat	Represents the options of loading xml file.
NewXmlLoadOptions_LoadOptions	Constructs from a parent object.

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetStartCell	Gets and sets the start cell.
SetStartCell	Gets and sets the start cell.
IsXmlMap	Indicates whether mapping xml to Excel.The default value is false.
SetIsXmlMap	Indicates whether mapping xml to Excel.The default value is false.
GetContainsMultipleWorksheets	Indicates whether importing xml as multiple worksheets.
SetContainsMultipleWorksheets	Indicates whether importing xml as multiple worksheets.
GetConvertNumericOrDate	Indicates whether converting the value in xml file to numeric or date.
SetConvertNumericOrDate	Indicates whether converting the value in xml file to numeric or date.
Get_NumberFormat	Gets and sets the format of numeric value.
SetNumberFormat	Gets and sets the format of numeric value.
Get_DateFormat	Gets and sets the format of date value.
SetDateFormat	Gets and sets the format of date value.
GetIgnoreRootAttributes	Indicates whether ignore attributes of the root element.
SetIgnoreRootAttributes	Indicates whether ignore attributes of the root element.
GetLoadFormat	Gets the load format.
GetPassword	Gets and set the password of the workbook.
SetPassword	Gets and set the password of the workbook.
GetParsingFormulaOnOpen	Indicates whether parsing the formula when reading the file.
SetParsingFormulaOnOpen	Indicates whether parsing the formula when reading the file.
GetParsingPivotCachedRecords	Indicates whether parsing pivot cached records when loading the file.The default value is false.
SetParsingPivotCachedRecords	Indicates whether parsing pivot cached records when loading the file.The default value is false.
SetPaperSize	Sets the default print paper size from default printer’s setting.
GetLanguageCode	Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file.
SetLanguageCode	Gets or sets the user interface language of the Workbook version based on CountryCode that has saved the file.
GetRegion	Gets or sets the system regional settings based on CountryCode at the time the file was loaded.
SetRegion	Gets or sets the system regional settings based on CountryCode at the time the file was loaded.
GetDefaultStyleSettings	Gets the default style settings for initializing styles of the workbook
GetInterruptMonitor	Gets and sets the interrupt monitor.
SetInterruptMonitor	Gets and sets the interrupt monitor.
GetIgnoreNotPrinted	Ignore the data which are not printed if directly printing the file
SetIgnoreNotPrinted	Ignore the data which are not printed if directly printing the file
GetCheckDataValid	Check whether data is valid in the template file.
SetCheckDataValid	Check whether data is valid in the template file.
GetCheckExcelRestriction	Whether 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 such as by Cell.PutValue(string), if this property is true, you will get an Exception.If this property is false, we will accept your input string value as the cell’s value so that lateryou can output the complete string value for other file formats such as CSV.However, if you have set such kind of value that is invalid for excel file format,you should not save the workbook as excel file format later. Otherwise there may be unexpected error for the generated excel file.
SetCheckExcelRestriction	Whether 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 such as by Cell.PutValue(string), if this property is true, you will get an Exception.If this property is false, we will accept your input string value as the cell’s value so that lateryou can output the complete string value for other file formats such as CSV.However, if you have set such kind of value that is invalid for excel file format,you should not save the workbook as excel file format later. Otherwise there may be unexpected error for the generated excel file.
GetKeepUnparsedData	Whether keep the unparsed data in memory for the Workbook when it is loaded from template file. Default is true.
SetKeepUnparsedData	Whether keep the unparsed data in memory for the Workbook when it is loaded from template file. Default is true.
GetLoadFilter	The filter to denote how to load data.
SetLoadFilter	The filter to denote how to load data.
GetMemorySetting	Gets or sets the memory usage options.
SetMemorySetting	Gets or sets the memory usage options.
GetAutoFitterOptions	Gets and sets the auto fitter options
SetAutoFitterOptions	Gets and sets the auto fitter options
GetAutoFilter	Indicates whether auto filtering the data when loading the files.
SetAutoFilter	Indicates whether auto filtering the data when loading the files.
GetFontConfigs	Gets and sets individual font configs.Only works for the which uses this to load.
SetFontConfigs	Gets and sets individual font configs.Only works for the which uses this to load.
GetIgnoreUselessShapes	Indicates whether ignoring useless shapes.
SetIgnoreUselessShapes	Indicates whether ignoring useless shapes.
GetPreservePaddingSpacesInFormula	Indicates whether preserve those spaces and line breaks that are padded between formula tokenswhile getting and setting formulas.Default value is false.
SetPreservePaddingSpacesInFormula	Indicates whether preserve those spaces and line breaks that are padded between formula tokenswhile getting and setting formulas.Default value is false.