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.
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)
Strategy for duplicate names of columns.
The value of the property is RenameStrategy integer constant.
com.aspose.cells.ExportTableOptions