Class ExportTableOptions

ExportTableOptions class

Represents all export table options.

public class ExportTableOptions

Constructors

NameDescription
ExportTableOptions()The default constructor.

Properties

NameDescription
AllowDBNull { get; set; }This value indicates whether DBNulls are allowed in this table.
CheckMixedValueType { get; set; }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.
DataTable { get; set; }Gets and sets the DataTable which columns’ data type is assigned.
ExportAsHtmlString { get; set; }Exports the html string value of the cells to the DataTable.
ExportAsString { get; set; }Exports the string value of the cells to the DataTable.
ExportColumnName { get; set; }Indicates whether the data in the first row are exported to the column name of the DataTable. The default value is false.
FormatStrategy { get; set; }Gets and sets the format strategy when exporting the value as string value.
Indexes { get; set; }The indexes of columns/rows which should be exported out.
IsVertical { get; set; }True if a row in Workbook file represents a row in DataTable. False if a column in Workbook file represents a row in DataTable.
PlotVisibleCells { get; set; }Only exports visible cells.
PlotVisibleColumns { get; set; }Only exports visible columns.
PlotVisibleRows { get; set; }Only exports visible rows.
RenameStrategy { get; set; }Strategy for duplicate names of columns.
SkipErrorValue { get; set; }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.

Methods

NameDescription
virtual PreprocessExportedValue(int, int, CellValue)Preprocess the value of current cell to be exported.

Remarks

If there are some special requirements about the exporting, such as ignoring error values, user may extend this class to overwrite corresponding apis to achive the goal.

See Also