TxtSaveOptions Class

TxtSaveOptions class

Represents the save options for csv/tab delimited/other text format.

type TxtSaveOptions struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description
NewTxtSaveOptions	Creates text file save options.
NewTxtSaveOptions_SaveFormat	Creates text file save options.
NewTxtSaveOptions_SaveOptions	Constructs from a parent object.

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetSeparator	Gets and sets char Delimiter of text file.
SetSeparator	Gets and sets char Delimiter of text file.
GetSeparatorString	Gets and sets a string value as separator.
SetSeparatorString	Gets and sets a string value as separator.
GetEncoding	Gets and sets the default encoding.
SetEncoding	Gets and sets the default encoding.
GetQuoteType	Gets or sets how to quote values in the exported text file.
SetQuoteType	Gets or sets how to quote values in the exported text file.
GetFormatStrategy	Gets and sets the format strategy when exporting the cell value as string.
SetFormatStrategy	Gets and sets the format strategy when exporting the cell value as string.
GetTrimLeadingBlankRowAndColumn	Indicates whether leading blank rows and columns should be trimmed like what ms excel does.Default is true.
SetTrimLeadingBlankRowAndColumn	Indicates whether leading blank rows and columns should be trimmed like what ms excel does.Default is true.
GetTrimTailingBlankCells	Indicates whether tailing blank cells in one row should be trimmed. Default is false.
SetTrimTailingBlankCells	Indicates whether tailing blank cells in one row should be trimmed. Default is false.
GetKeepSeparatorsForBlankRow	Indicates whether separators should be output for blank row.Default value is false so by default the content for blank row will be empty.
SetKeepSeparatorsForBlankRow	Indicates whether separators should be output for blank row.Default value is false so by default the content for blank row will be empty.
GetExportArea	The range of cells to be exported.
SetExportArea	The range of cells to be exported.
GetExportQuotePrefix	Indicates whether the single quote sign should be exported as part of the value of one cellwhen Style.QuotePrefix is true for it. Default is false.
SetExportQuotePrefix	Indicates whether the single quote sign should be exported as part of the value of one cellwhen Style.QuotePrefix is true for it. Default is false.
GetExportAllSheets	Indicates whether exporting all sheets to the text file.If it is false, only export the activesheet, just like MS Excel.
SetExportAllSheets	Indicates whether exporting all sheets to the text file.If it is false, only export the activesheet, just like MS Excel.
GetSaveFormat	Gets the save file format.
GetClearData	Make the workbook empty after saving the file.
SetClearData	Make the workbook empty after saving the file.
GetCachedFileFolder	The folder for temporary files that may be used as data cache.
SetCachedFileFolder	The folder for temporary files that may be used as data cache.
GetValidateMergedAreas	Indicates whether validate merged cells before saving the file.
SetValidateMergedAreas	Indicates whether validate merged cells before saving the file.
GetMergeAreas	Indicates whether merge the areas of conditional formatting and validation before saving the file.
SetMergeAreas	Indicates whether merge the areas of conditional formatting and validation before saving the file.
GetCreateDirectory	If true and the directory does not exist, the directory will be automatically created before saving the file.
SetCreateDirectory	If true and the directory does not exist, the directory will be automatically created before saving the file.
GetSortNames	Indicates whether sorting defined names before saving file.
SetSortNames	Indicates whether sorting defined names before saving file.
GetSortExternalNames	Indicates whether sorting external defined names before saving file.
SetSortExternalNames	Indicates whether sorting external defined names before saving file.
GetRefreshChartCache	Indicates whether refreshing chart cache data
SetRefreshChartCache	Indicates whether refreshing chart cache data
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, it will be truncated.
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, it will be truncated.
GetUpdateSmartArt	Indicates whether updating smart art setting.The default value is false.
SetUpdateSmartArt	Indicates whether updating smart art setting.The default value is false.
GetEncryptDocumentProperties	Indicates whether encrypt document properties when saving as .xls file.The default value is true.
SetEncryptDocumentProperties	Indicates whether encrypt document properties when saving as .xls file.The default value is true.