com.aspose.cells

com.aspose.cells

Class ExportTableOptions

  • java.lang.Object
    • com.aspose.cells.ExportTableOptions
public class ExportTableOptions 
extends java.lang.Object

Represents all export table options.

Constructor Summary
ExportTableOptions()
 
Property Getters/Setters Summary
booleangetCheckMixedValueType()
void
setCheckMixedValueType(booleanvalue)
           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()
void
setExportAsHtmlString(booleanvalue)
           Exports the html string value of the cells to the DataTable.
booleangetExportAsString()
void
setExportAsString(booleanvalue)
           Exports the string value of the cells to the DataTable.
booleangetExportColumnName()
void
setExportColumnName(booleanvalue)
           Indicates whether the data in the first row are exported to the column name of the DataTable. The default value is false.
intgetFormatStrategy()
void
setFormatStrategy(intvalue)
           Gets and sets the format strategy when exporting the value as string value. The value of the property is CellValueFormatStrategy integer constant.
int[]getIndexes()
void
setIndexes(int[]value)
           The indexes of columns/rows which should be exported out.
booleanisVertical()
void
setVertical(booleanvalue)
           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()
void
setPlotVisibleCells(booleanvalue)
           Only exports visible cells.
booleangetPlotVisibleColumns()
void
setPlotVisibleColumns(booleanvalue)
           Only exports visible columns.
booleangetPlotVisibleRows()
void
setPlotVisibleRows(booleanvalue)
           Only exports visible rows.
intgetRenameStrategy()
void
setRenameStrategy(intvalue)
           Renames strategy when columns contains the duplicate names. The value of the property is RenameStrategy integer constant.
booleangetSkipErrorValue()
void
setSkipErrorValue(booleanvalue)
           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 should 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.

    setExportColumnName

    public voidsetExportColumnName(booleanvalue)
    Indicates whether the data in the first row are exported to the column name of the DataTable. The default value is false.

    setSkipErrorValue

    public voidsetSkipErrorValue(booleanvalue)
    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.

    setPlotVisibleCells

    public voidsetPlotVisibleCells(booleanvalue)
    Only exports visible cells.

    setPlotVisibleRows

    public voidsetPlotVisibleRows(booleanvalue)
    Only exports visible rows.

    setPlotVisibleColumns

    public voidsetPlotVisibleColumns(booleanvalue)
    Only exports visible columns.

    setExportAsString

    public voidsetExportAsString(booleanvalue)
    Exports the string value of the cells to the DataTable.

    setExportAsHtmlString

    public voidsetExportAsHtmlString(booleanvalue)
    Exports the html string value of the cells to the DataTable.

    setFormatStrategy

    public voidsetFormatStrategy(intvalue)
    Gets and sets the format strategy when exporting the value as string value. The value of the property is CellValueFormatStrategy integer constant.

    setCheckMixedValueType

    public voidsetCheckMixedValueType(booleanvalue)
    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.

    setVertical

    public voidsetVertical(booleanvalue)
    True if a row in Workbook file represents a row in DataTable. False if a column in Workbook file represents a row in DataTable.

    setIndexes

    public voidsetIndexes(int[]value)
    The indexes of columns/rows which should be exported out.

    setRenameStrategy

    public voidsetRenameStrategy(intvalue)
    Renames strategy when columns contains the duplicate names. The value of the property is RenameStrategy integer constant.