TxtLoadOptions Class
Contents
[
Hide
]TxtLoadOptions class
Represents the options for loading text file.
type TxtLoadOptions struct {
ptr unsafe.Pointer
}
Constructors
Method | Description |
---|---|
NewTxtLoadOptions | Creates the options for loading text file. |
NewTxtLoadOptions_LoadFormat | Creates the options for loading text file. |
NewTxtLoadOptions_AbstractTextLoadOptions | Constructs from a parent object. |
Methods
Method | Description |
---|---|
IsNull | Checks whether the implementation object is nullptr. |
GetSeparator | Gets and sets character separator of text file. |
SetSeparator | Gets and sets character separator of text file. |
GetSeparatorString | Gets and sets a string value as separator. |
SetSeparatorString | Gets and sets a string value as separator. |
IsMultiEncoded | True means that the file contains several encoding. |
SetIsMultiEncoded | True means that the file contains several encoding. |
GetHasFormula | Indicates whether the text is formula if it starts with “=”. |
SetHasFormula | Indicates whether the text is formula if it starts with “=”. |
GetHasTextQualifier | Whether there is text qualifier for cell value. Default is true. |
SetHasTextQualifier | Whether there is text qualifier for cell value. Default is true. |
GetTextQualifier | Specifies the text qualifier for cell values. Default qualifier is ‘"’. |
SetTextQualifier | Specifies the text qualifier for cell values. Default qualifier is ‘"’. |
GetTreatConsecutiveDelimitersAsOne | Whether consecutive delimiters should be treated as one. |
SetTreatConsecutiveDelimitersAsOne | Whether consecutive delimiters should be treated as one. |
GetTreatQuotePrefixAsValue | Indicates whether the leading single quote sign should be taken as part of the value of one cell.Default is true. If it is false, the leading single quote will be removed from corresponding cell’s valueand |
SetTreatQuotePrefixAsValue | Indicates whether the leading single quote sign should be taken as part of the value of one cell.Default is true. If it is false, the leading single quote will be removed from corresponding cell’s valueand |
GetExtendToNextSheet | Whether extends data to next sheet when the rows or columns of data exceed limit.Default is false. |
SetExtendToNextSheet | Whether extends data to next sheet when the rows or columns of data exceed limit.Default is false. |
GetHeaderRowsCount | The count of header rows to be repeated for extended sheets. |
SetHeaderRowsCount | The count of header rows to be repeated for extended sheets. |
GetHeaderColumnsCount | The count of header columns to be repeated for extended sheets. |
SetHeaderColumnsCount | The count of header columns to be repeated for extended sheets. |
GetMaxRowCount | The maximum count of rows to be imported for one sheet. |
SetMaxRowCount | The maximum count of rows to be imported for one sheet. |
GetMaxColumnCount | The maximum count of columns to be imported for one sheet. |
SetMaxColumnCount | The maximum count of columns to be imported for one sheet. |
GetEncoding | Gets and sets the default encoding. Only applies for csv file. |
SetEncoding | Gets and sets the default encoding. Only applies for csv file. |
GetLoadStyleStrategy | Indicates the strategy to apply style for parsed values when converting string value to number or datetime. |
SetLoadStyleStrategy | Indicates the strategy to apply style for parsed values when converting string value to number or datetime. |
GetConvertNumericData | Gets or sets a value that indicates whether the string in text file is converted to numeric data. |
SetConvertNumericData | Gets or sets a value that indicates whether the string in text file is converted to numeric data. |
GetConvertDateTimeData | Gets or sets a value that indicates whether the string in text file is converted to date data. |
SetConvertDateTimeData | Gets or sets a value that indicates whether the string in text file is converted to date data. |
GetKeepPrecision | Indicates whether not parsing a string value if the length is 15. |
SetKeepPrecision | Indicates whether not parsing a string value if the length is 15. |