Class ImportTableOptions
Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)
Represents the options of importing data into cells.
public class ImportTableOptionsInheritance
Inherited Members
object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Constructors
ImportTableOptions()
Creates the default importing options.
public ImportTableOptions()Properties
CheckMergedCells
Indicates whether checking merged cells.
public bool CheckMergedCells { get; set; }Property Value
ColumnIndexes
Gets or sets the columns(0-based) to import from data source. null means all columns should be imported.
public int[] ColumnIndexes { get; set; }Property Value
int[]
ConvertGridStyle
Indicates whether apply the style of the grid view to cells.
public bool ConvertGridStyle { get; set; }Property Value
ConvertNumericData
Gets or sets a value that indicates whether the string value should be converted to numeric or date value.
public bool ConvertNumericData { get; set; }Property Value
DateFormat
Gets or sets date format string for cells with imported datetime values.
public string DateFormat { get; set; }Property Value
DefaultValues
Default value for the value in the table is null.
public object[] DefaultValues { get; set; }Property Value
object[]
ExportCaptionAsFieldName
Indicates whether exporting caption as field name
public bool ExportCaptionAsFieldName { get; set; }Property Value
Remarks
Only works for DataTable.
InsertRows
Indicates whether new rows should be added for importing data records.
public bool InsertRows { get; set; }Property Value
IsFieldNameShown
Indicates whether field name should be imported.
public bool IsFieldNameShown { get; set; }Property Value
IsFormulas
Indicates whether the data are formulas.
public bool[] IsFormulas { get; set; }Property Value
bool[]
IsHtmlString
Indicates whether the value contains html tags.
public bool IsHtmlString { get; set; }Property Value
NumberFormats
Gets or sets the number formats
public string[] NumberFormats { get; set; }Property Value
string[]
ShiftFirstRowDown
Indicates whether shifting the first row down when inserting rows.
public bool ShiftFirstRowDown { get; set; }Property Value
TotalColumns
Gets or sets total column count to import from data source. -1 means all rows of given data source.
public int TotalColumns { get; set; }Property Value
TotalRows
Gets or sets total row count to import from data source. -1 means all rows of given data source.
public int TotalRows { get; set; }