TDataConnectionTextImportProperties Class
This element contains all of the text import settings.
Syntax
Namespace: FlexCel.Core
public class TDataConnectionTextImportProperties
Methods
Name | Description |
---|---|
Equals | Returns true if both objects are the same. |
GetHashCode | Returns the hashcode of the object. |
Properties
Name | Description |
---|---|
TextFields | Field definitions. This property is never null, and by modifying it you modify the parent TextImportProperties too. |
PromptForFileName | Flag indicating whether the user wants to be prompted for the file name on refresh. If false, then the user is not prompted.If true or not present, then the user is prompted. |
FileType | Ignorable attribute. Determines the kind of character set to use during import. Only one of FileType and CharacterSet or CodePage shall be specified. |
CharacterSet | Name of the character set associated with the text file. Values for this attribute are restricted to the names and aliases listed in the IANA CHARACTER SETS listing found at http://www.iana.org/assignments/character-sets. If this attribute is not present then the CodePage attribute is used. |
FirstRow | Indicates at what row of the file to start the data import. All unsignedInt values are permitted, although it's possible that firstRow is higher than the number of rows in the text file, in which case no data is imported. |
SourceFile | Path to the text file to use to import external data. Can be expressed in URI or systemspecific file path notation. |
IsDelimited | True if the file is Tab or character delimited. false if the file should be parsed according to fixed length fields. |
DecimalSeparator | The decimal separator character. This and the thousands attribute are used only when data in the text file contains decimal and thousands separators that are different from those used on the computer, due to a different language setting being used. |
ThousandsSeparator | The thousands separator character. This and the decimal attribute are used only when data in the text file contains decimal and thousands separators that are different from those used on the computer, due to a different language setting being used.Please refer to the decimal attribute description above for a Table describing the behavior. Strings values of this attribute are expected to be one character in length. |
TabIsDelimiter | Flag indicating whether to treat tab characters as field delimiters. If false, then tabs will not be used as delimiters.If true or not present, then they are used as delimiters. |
SpaceIsDelimiter | Flag indicating whether to treat space characters as field delimiters. |
CommaIsDelimiter | Flag indicating whether to treat comma characters as field delimiters. |
SemicolonIsDelimiter | Flag indicating whether to treat semicolon characters as field delimiters. |
ConsecutiveDelimiters | Flag indicating whether consecutive delimiters should be treated as just one delimiter. If this flag is true than it's possible or even likely that some rows will return more fields than others, and these fields will always fill cells in the worksheet from left to right. |
Qualifier | Character used as the text string qualifier. |
Delimiter | User-specified character to be treated as a field delimiter. Only single characters are supported. |