Contains the Text Import Wizard settings.
Element |
Description |
FormatSettings |
Contains format settings for the columns of imported text. |
Delimiters |
Contains the delimiters used to parse imported text. |
Comma |
Specifies whether the comma character is used as a delimiter when importing text. |
Consecutive |
Specifies whether consecutive delimiters are treated as one when importing text. |
Custom |
Contains a custom character to be used as a delimiter when importing text. |
SemiColon |
Specifies whether the semicolon character is used as a delimiter when importing text. |
Space |
Specifies whether the space character is used as a delimiter when importing text. |
Tab |
Specifies whether the tab character is used as a delimiter when importing text. |
TextQualifier |
Contains the character to be used for identifying text when importing text data. |
Name |
Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. |
Source |
Contains the name of a published item or range, or specifies the character set of a text data source. |
StartRow |
Specifies the first row of a text data source to begin text import. |
Decimal |
Contains the decimal separator character used to recognize numeric data when importing text. |
ThousandSeparator |
Contains the thousands separator character used to recognize numeric data when importing text. |
None.