ImportTableOptions Class

ImportTableOptions class

Represents the options of importing data into cells.


type ImportTableOptions struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription
NewImportTableOptionsCreates the default importing options.

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
GetConvertGridStyleIndicates whether apply the style of the grid view to cells.
SetConvertGridStyleIndicates whether apply the style of the grid view to cells.
GetConvertNumericDataGets or sets a value that indicates whether the string value should be converted to numeric or date value.
SetConvertNumericDataGets or sets a value that indicates whether the string value should be converted to numeric or date value.
GetInsertRowsIndicates whether new rows should be added for importing data records.
SetInsertRowsIndicates whether new rows should be added for importing data records.
GetShiftFirstRowDownIndicates whether shifting the first row down when inserting rows.
SetShiftFirstRowDownIndicates whether shifting the first row down when inserting rows.
IsFieldNameShownIndicates whether field name should be imported.
SetIsFieldNameShownIndicates whether field name should be imported.
GetExportCaptionAsFieldNameIndicates whether exporting caption as field name
SetExportCaptionAsFieldNameIndicates whether exporting caption as field name
GetDateFormatGets or sets date format string for cells with imported datetime values.
SetDateFormatGets or sets date format string for cells with imported datetime values.
GetNumberFormatsGets or sets the number formats
SetNumberFormatsGets or sets the number formats
GetIsFormulasIndicates whether the data are formulas.
SetIsFormulasIndicates whether the data are formulas.
GetTotalRowsGets or sets total row count to import from data source. -1 means all rows of given data source.
SetTotalRowsGets or sets total row count to import from data source. -1 means all rows of given data source.
GetTotalColumnsGets or sets total column count to import from data source. -1 means all rows of given data source.
SetTotalColumnsGets or sets total column count to import from data source. -1 means all rows of given data source.
GetColumnIndexesGets or sets the columns(0-based) to import from data source. null means all columns should be imported.
SetColumnIndexesGets or sets the columns(0-based) to import from data source. null means all columns should be imported.
GetDefaultValuesDefault value for the value in the table is null.
SetDefaultValuesDefault value for the value in the table is null.
IsHtmlStringIndicates whether the value contains html tags.
SetIsHtmlStringIndicates whether the value contains html tags.
GetCheckMergedCellsIndicates whether checking merged cells.
SetCheckMergedCellsIndicates whether checking merged cells.