TxtSaveOptions

TxtSaveOptions class

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

public class TxtSaveOptions : SaveOptions

Constructors

Name Description
TxtSaveOptions() Creates text file save options.
TxtSaveOptions(SaveFormat) Creates text file save options.

Properties

Name Description
AlwaysQuoted { get; set; } (Obsolete.) Indicates whether always adding ‘"’ for each field. If true then all values will be quoted; If false then values will only be quoted when needed(for example, when values contain special characters such as ‘"’ , ‘\n’ or separator character). Default is false.
CachedFileFolder { get; set; } The cached file folder is used to store some large data.(Inherited from SaveOptions.)
ClearData { get; set; } Make the workbook empty after saving the file.(Inherited from SaveOptions.)
CreateDirectory { get; set; } If true and the directory does not exist, the directory will be automatically created before saving the file.(Inherited from SaveOptions.)
Encoding { get; set; } Gets and sets the default encoding.
ExportAllSheets { get; set; } Indicates whether exporting all sheets to the text file. If it is false, only export the activesheet, just like MS Excel.
ExportArea { get; set; } The range of cells to be exported.
ExportQuotePrefix { get; set; } Indicates whether the single quote sign should be exported as part of the value of one cell when QuotePrefix is true for it. Default is false.
FormatStrategy { get; set; } Gets and sets the format strategy when exporting the cell value as string.
KeepSeparatorsForBlankRow { get; set; } Indicates whether separators should be output for blank row. Default value is false so by default the content for blank row will be empty.
LightCellsDataProvider { get; set; } The Data provider to provide cells data for saving workbook in light mode.
MergeAreas { get; set; } Indicates whether merge the areas of conditional formatting and validation before saving the file.(Inherited from SaveOptions.)
QuoteType { get; set; } Gets or sets how to quote values in the exported text file.
RefreshChartCache { get; set; } Indicates whether refreshing chart cache data(Inherited from SaveOptions.)
SaveFormat { get; } Gets the save file format.(Inherited from SaveOptions.)
Separator { get; set; } Gets and sets char Delimiter of text file.
SeparatorString { get; set; } Gets and sets a string value as separator.
SortExternalNames { get; set; } Indicates whether sorting external defined names before saving file.(Inherited from SaveOptions.)
SortNames { get; set; } Indicates whether sorting defined names before saving file.(Inherited from SaveOptions.)
TrimLeadingBlankRowAndColumn { get; set; } Indicates whether leading blank rows and columns should be trimmed like what ms excel does. Default is true.
TrimTailingBlankCells { get; set; } Indicates whether tailing blank cells in one row should be trimmed. Default is false.
UpdateSmartArt { get; set; } Indicates whether updating smart art setting. The default value is false.(Inherited from SaveOptions.)
ValidateMergedAreas { get; set; } Indicates whether validate merged cells before saving the file.(Inherited from SaveOptions.)
WarningCallback { get; set; } Gets or sets warning callback.(Inherited from SaveOptions.)

See Also