ExportTableOptions Properties

The ExportTableOptions type exposes the following members.

Public propertyCheckMixedValueType
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.
Public propertyDataTable
Gets and sets the DataTable which columns' data type is assigned.
Public propertyExportAsHtmlString
Exports the html string value of the cells to the DataTable.
Public propertyExportAsString
Exports the string value of the cells to the DataTable.
Public propertyExportColumnName
Indicates whether the data in the first row are exported to the column name of the DataTable. The default value is false.
Public propertyFormatStrategy
Gets and sets the format strategy when exporting the value as string value.
Public propertyIndexes
The indexes of columns/rows which should be exported out.
Public propertyIsVertical
True if a row in Workbook file represents a row in DataTable. False if a column in Workbook file represents a row in DataTable.
Public propertyPlotVisibleCells
Only exports visible cells.
Public propertyPlotVisibleColumns
Only exports visible columns.
Public propertyPlotVisibleRows
Only exports visible rows.
Public propertyRenameStrategy
Renames strategy when columns contains the duplicate names.
Public propertySkipErrorValue
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.
See Also