com.aspose.cells
Class TxtSaveOptions

java.lang.Object
  SaveOptions
      com.aspose.cells.TxtSaveOptions

public class TxtSaveOptions 
extends SaveOptions

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 format of the text file.

public char getSeparator() / public void setSeparator(char value)

Gets and sets char Delimiter of text file.

public java.lang.String getSeparatorString() / public void setSeparatorString(java.lang.String value)

Gets and sets a string value as separator.

public com.aspose.cells.Encoding getEncoding() / public void setEncoding(com.aspose.cells.Encoding value)

Gets and sets the default encoding.

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 values will only be quoted when needed(for example, 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.

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.

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.

public LightCellsDataProvider getLightCellsDataProvider() / public void setLightCellsDataProvider(LightCellsDataProvider value)

The Data provider to provide cells data for saving workbook in light mode.

public boolean getTrimLeadingBlankRowAndColumn() / public void setTrimLeadingBlankRowAndColumn(boolean value)

Indicates whether leading blank rows and columns should be trimmed like what ms excel does. Default is true.

Same with the rule in ms excel, a row/column will not be taken as blank if it has custom style, even if it contains no cell data. When saving with LightCells mode, this option takes no effect. User should control the output range by the implementation of LightCellsDataProvider or by speicifing ExportArea

public boolean getTrimTailingBlankCells() / public void setTrimTailingBlankCells(boolean value)

Indicates whether tailing blank cells in one row should be trimmed. Default is false.

When saving with LightCells mode and the ExportArea has not been specified, this option takes no effect and one row will be extended to just the last cell provided by the implementation LightCellsDataProvider

public boolean getKeepSeparatorsForBlankRow() / public void setKeepSeparatorsForBlankRow(boolean value)

Indicates whether separators should be output for blank row. Default value is false so by default the content for blank row will be empty.

public CellArea getExportArea() / public void setExportArea(CellArea value)

The range of cells to be exported.

If the exported area has been specified, TrimLeadingBlankRowAndColumn will takes no effect.

public boolean getExportQuotePrefix() / public void setExportQuotePrefix(boolean value)

Indicates whether the single quote sign should be exported as part of the value of one cell when Style.QuotePrefix is true for it. Default is false.

public boolean getExportAllSheets() / public void setExportAllSheets(boolean value)

Indicates whether exporting all sheets to the text file. If it is false, only export the activesheet, just like MS Excel.

The defult value is false.

public int getSaveFormat()

Gets the save file format. The value of the property is SaveFormat integer constant.

public boolean getClearData() / public void setClearData(boolean value)

Make the workbook empty after saving the file.

public java.lang.String getCachedFileFolder() / public void setCachedFileFolder(java.lang.String value)

The cached file folder is used to store some large data.

public boolean getValidateMergedAreas() / public void setValidateMergedAreas(boolean value)

Indicates whether validate merged cells before saving the file.

The default value is false.

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.

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.

public boolean getSortNames() / public void setSortNames(boolean value)

Indicates whether sorting defined names before saving file.

public boolean getSortExternalNames() / public void setSortExternalNames(boolean value)

Indicates whether sorting external defined names before saving file.

public boolean getRefreshChartCache() / public void setRefreshChartCache(boolean value)

Indicates whether refreshing chart cache data

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.

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.

public IWarningCallback getWarningCallback() / public void setWarningCallback(IWarningCallback value)

Gets or sets warning callback.

public boolean getUpdateSmartArt() / public void setUpdateSmartArt(boolean value)

Indicates whether updating smart art setting. The default value is false.

Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.