ImportTableOptions Class

Represents the options of importing data into cells.
Inheritance Hierarchy
SystemObject
  Aspose.CellsImportTableOptions

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 20.1.0.0 (20.1)
Syntax
public class ImportTableOptions

The ImportTableOptions type exposes the following members.

Constructors
  NameDescription
Public methodImportTableOptions
Creates the default imporing options.
Properties
  NameDescription
Public propertyCheckMergedCells
Indicates whether checking merged cells.
Public propertyColumnIndexes
Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
Public propertyConvertGridStyle
Indicates whether apply the style of the grid view to cells.
Public propertyConvertNumericData
Gets or sets a value that indicates whether the string value should be converted to numeric or date value.
Public propertyDateFormat
Gets or sets date format string for cells with imported datetime values.
Public propertyDefaultValues
Default value for the value in the table is null.
Public propertyInsertRows
Indicates whether new rows should be added for importing data records.
Public propertyIsFieldNameShown
Indicates whether field name should be imported.
Public propertyIsFormulas
Indicates whether the data are formulas.
Public propertyIsHtmlString
Indicates whether the value contains html tags.
Public propertyNumberFormats
Gets or sets the number formats
Public propertyShiftFirstRowDown
Indicates whether shifting the first row down when inserting rows.
Public propertyTotalColumns
Gets or sets total column count to import from data source. -1 means all rows of given data source.
Public propertyTotalRows
Gets or sets total row count to import from data source. -1 means all rows of given data source.
Methods
  NameDescription
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
See Also