com.aspose.cells
Class ExportTableOptions

java.lang.Object
    extended by com.aspose.cells.ExportTableOptions

public class ExportTableOptions 
extends java.lang.Object

Represents all export table options.

Constructor Summary
ExportTableOptions()
          
 
Property Getters/Setters Summary
booleangetCheckMixedValueType()
voidsetCheckMixedValueType(boolean value)
           False, Aspose.Cells will set the DataColumn's type by the value type of the first row for performance. True, Aspose.Cells will check whether the value type in the column are mixed before set the DataColumn's type And the value type are mixed, the DataColumn's type will be string.
booleangetExportAsHtmlString()
voidsetExportAsHtmlString(boolean value)
           Exports the html string value of the cells to the DataTable.
booleangetExportAsString()
voidsetExportAsString(boolean value)
           Exports the string value of the cells to the DataTable.
booleangetExportColumnName()
voidsetExportColumnName(boolean value)
           Indicates whether the data in the first row are exported to the column name of the DataTable. The default value is false.
intgetFormatStrategy()
voidsetFormatStrategy(int value)
           Gets and sets the format strategy when exporting the value as string value. The value of the property is CellValueFormatStrategy integer constant.
int[]getIndexes()
voidsetIndexes(int[] value)
           The indexes of columns/rows which shoudl be exported out.
booleanisVertical()
voidsetVertical(boolean value)
           True if a row in Workbook file represents a row in DataTable. False if a column in Workbook file represents a row in DataTable.
booleangetPlotVisibleCells()
voidsetPlotVisibleCells(boolean value)
           Only exports visible cells.
booleangetPlotVisibleColumns()
voidsetPlotVisibleColumns(boolean value)
           Only exports visible columns.
booleangetPlotVisibleRows()
voidsetPlotVisibleRows(boolean value)
           Only exports visible rows.
intgetRenameStrategy()
voidsetRenameStrategy(int value)
           Renames strategy when columns contains the duplicate names. The value of the property is RenameStrategy integer constant.
booleangetSkipErrorValue()
voidsetSkipErrorValue(boolean value)
           Indicates whether skip invalid value for the column. For example,if the column type is decimal ,the value is greater than decimal.MaxValue and this property is true,we will not throw exception again. The default value is false.
 

Constructor Detail

ExportTableOptions

public ExportTableOptions()

Property Getters/Setters Detail

getExportColumnName/setExportColumnName

public boolean getExportColumnName() / public void setExportColumnName(boolean value)
Indicates whether the data in the first row are exported to the column name of the DataTable. The default value is false.

getSkipErrorValue/setSkipErrorValue

public boolean getSkipErrorValue() / public void setSkipErrorValue(boolean value)
Indicates whether skip invalid value for the column. For example,if the column type is decimal ,the value is greater than decimal.MaxValue and this property is true,we will not throw exception again. The default value is false.

getPlotVisibleCells/setPlotVisibleCells

public boolean getPlotVisibleCells() / public void setPlotVisibleCells(boolean value)
Only exports visible cells.

getPlotVisibleRows/setPlotVisibleRows

public boolean getPlotVisibleRows() / public void setPlotVisibleRows(boolean value)
Only exports visible rows.

getPlotVisibleColumns/setPlotVisibleColumns

public boolean getPlotVisibleColumns() / public void setPlotVisibleColumns(boolean value)
Only exports visible columns.

getExportAsString/setExportAsString

public boolean getExportAsString() / public void setExportAsString(boolean value)
Exports the string value of the cells to the DataTable.

getExportAsHtmlString/setExportAsHtmlString

public boolean getExportAsHtmlString() / public void setExportAsHtmlString(boolean value)
Exports the html string value of the cells to the DataTable.

getFormatStrategy/setFormatStrategy

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

getCheckMixedValueType/setCheckMixedValueType

public boolean getCheckMixedValueType() / public void setCheckMixedValueType(boolean value)
False, Aspose.Cells will set the DataColumn's type by the value type of the first row for performance. True, Aspose.Cells will check whether the value type in the column are mixed before set the DataColumn's type And the value type are mixed, the DataColumn's type will be string.

isVertical/setVertical

public boolean isVertical() / public void setVertical(boolean value)
True if a row in Workbook file represents a row in DataTable. False if a column in Workbook file represents a row in DataTable.

getIndexes/setIndexes

public int[] getIndexes() / public void setIndexes(int[] value)
The indexes of columns/rows which shoudl be exported out.

getRenameStrategy/setRenameStrategy

public int getRenameStrategy() / public void setRenameStrategy(int value)
Renames strategy when columns contains the duplicate names. The value of the property is RenameStrategy integer constant.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.