com.aspose.cells

Class TxtSaveOptions

  • java.lang.Object
public class TxtSaveOptions 
extends SaveOptions

Repesents the save options for csv/tab delimitered/other text format.

Constructor Summary
TxtSaveOptions()
Creates text file save options.
TxtSaveOptions(intformat)
Creates text file save options.
 
Property Getters/Setters Summary
booleangetAlwaysQuoted()
void
setAlwaysQuoted(booleanvalue)
Indicates whether always adding '"' for each field. If true then all values will be quoted; If false then only quote values when needed(when values contain special characters such as '"' , '\n' or separator character). Default is false.
java.lang.StringgetCachedFileFolder()
void
setCachedFileFolder(java.lang.Stringvalue)
The cached file folder is used to store some large data.
booleangetClearData()
void
setClearData(booleanvalue)
Make the workbook empty after saving the file.
booleangetCreateDirectory()
void
setCreateDirectory(booleanvalue)
If true and the directory does not exist, the directory will be automatically created before saving the file.
booleangetEnableHTTPCompression()
void
Indicates if http compression is to be used in user's IIS.
EncodinggetEncoding()
void
Gets and sets the default encoding.Only applies for csv file.
intgetFormatStrategy()
void
Gets and sets the format strategy when exporting the cell value as string. The value of the property is CellValueFormatStrategy integer constant.
LightCellsDataProvidergetLightCellsDataProvider()
void
The Data provider to provide cells data for saving workbook in light mode.
booleangetMergeAreas()
void
setMergeAreas(booleanvalue)
Indicates whether merge the areas of conditional formatting and validation before saving the file.
java.lang.StringgetPdfExportImagesFolder()
void
setPdfExportImagesFolder(java.lang.Stringvalue)
The physical folder where images will be saved when exporting a workbook to Aspose.Pdf XML format. Default is an empty string.
intgetQuoteType()
void
setQuoteType(intvalue)
Gets or sets how to quote values in the exported text file. The value of the property is TxtValueQuoteType integer constant.
booleangetRefreshChartCache()
void
setRefreshChartCache(booleanvalue)
Indicates whether refreshing chart cache data
intgetSaveFormat()
Gets the save file format. The value of the property is SaveFormat integer constant.
chargetSeparator()
void
setSeparator(charvalue)
Gets and sets char Delimiter of text file.
java.lang.StringgetSeparatorString()
void
setSeparatorString(java.lang.Stringvalue)
Gets and sets the a string value as separator.
booleangetSortNames()
void
setSortNames(booleanvalue)
Indicates whether sorting defined names before saving file.
booleangetTrimLeadingBlankRowAndColumn()
void
Indicates whether leading blank rows and columns should be trimmed like what ms excel does.
booleangetValidateMergedAreas()
void
Indicates whether validate merged cells before saving the file.
IWarningCallbackgetWarningCallback()
void
Gets or sets warning callback.
 

    • Constructor Detail

      • TxtSaveOptions

        public TxtSaveOptions()
        Creates text file save options.
      • TxtSaveOptions

        public TxtSaveOptions(int format)
        Creates text file save options.
        Parameters:
        format - A SaveFormat value. The save foramt of the text file.
    • Property Getters/Setters Detail

      • getSeparator/setSeparator

        public char getSeparator() / public void setSeparator(char value)
        
        Gets and sets char Delimiter of text file.
      • getSeparatorString/setSeparatorString

        public java.lang.String getSeparatorString() / public void setSeparatorString(java.lang.String value)
        
        Gets and sets the a string value as separator.
      • getEncoding/setEncoding

        public Encoding getEncoding() / public void setEncoding(Encoding value)
        
        Gets and sets the default encoding.Only applies for csv file.
      • getAlwaysQuoted/setAlwaysQuoted

        public boolean getAlwaysQuoted() / public void setAlwaysQuoted(boolean value)
        
        Indicates whether always adding '"' for each field. If true then all values will be quoted; If false then only quote values when needed(when values contain special characters such as '"' , '\n' or separator character). Default is false. NOTE: This member is now obsolete. Instead, please use QuoteType property instead. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.
      • getQuoteType/setQuoteType

        public int getQuoteType() / public void setQuoteType(int value)
        
        Gets or sets how to quote values in the exported text file. The value of the property is TxtValueQuoteType integer constant.
      • getFormatStrategy/setFormatStrategy

        public int getFormatStrategy() / public void setFormatStrategy(int value)
        
        Gets and sets the format strategy when exporting the cell value as string. The value of the property is CellValueFormatStrategy integer constant.
      • getLightCellsDataProvider/setLightCellsDataProvider

        public LightCellsDataProvider getLightCellsDataProvider() / public void setLightCellsDataProvider(LightCellsDataProvider value)
        
        The Data provider to provide cells data for saving workbook in light mode.
      • getTrimLeadingBlankRowAndColumn/setTrimLeadingBlankRowAndColumn

        public boolean getTrimLeadingBlankRowAndColumn() / public void setTrimLeadingBlankRowAndColumn(boolean value)
        
        Indicates whether leading blank rows and columns should be trimmed like what ms excel does.
      • getSaveFormat

        public int getSaveFormat()
        
        Gets the save file format. The value of the property is SaveFormat integer constant.
      • getClearData/setClearData

        public boolean getClearData() / public void setClearData(boolean value)
        
        Make the workbook empty after saving the file.
      • getCachedFileFolder/setCachedFileFolder

        public java.lang.String getCachedFileFolder() / public void setCachedFileFolder(java.lang.String value)
        
        The cached file folder is used to store some large data.
      • getValidateMergedAreas/setValidateMergedAreas

        public boolean getValidateMergedAreas() / public void setValidateMergedAreas(boolean value)
        
        Indicates whether validate merged cells before saving the file. The default value is false.
      • getMergeAreas/setMergeAreas

        public boolean getMergeAreas() / public void setMergeAreas(boolean value)
        
        Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.
      • getCreateDirectory/setCreateDirectory

        public boolean getCreateDirectory() / public void setCreateDirectory(boolean value)
        
        If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.
      • getSortNames/setSortNames

        public boolean getSortNames() / public void setSortNames(boolean value)
        
        Indicates whether sorting defined names before saving file.
      • getRefreshChartCache/setRefreshChartCache

        public boolean getRefreshChartCache() / public void setRefreshChartCache(boolean value)
        
        Indicates whether refreshing chart cache data
      • getPdfExportImagesFolder/setPdfExportImagesFolder

        public java.lang.String getPdfExportImagesFolder() / public void setPdfExportImagesFolder(java.lang.String value)
        
        The physical folder where images will be saved when exporting a workbook to Aspose.Pdf XML format. Default is an empty string.
      • getEnableHTTPCompression/setEnableHTTPCompression

        public boolean getEnableHTTPCompression() / public void setEnableHTTPCompression(boolean value)
        
        Indicates if http compression is to be used in user's IIS. Please specify this property to true if http compression is used.
      • getWarningCallback/setWarningCallback

        public IWarningCallback getWarningCallback() / public void setWarningCallback(IWarningCallback value)
        
        Gets or sets warning callback.