2.4.330 TxtQry

The TxtQry record specifies information for a text query and that specifies the beginning of a collection of ExtString records, as defined by the Worksheet substreamABNF. The collection of ExtString records specifies the connection string for a query that retrieves external data.

rt (2 bytes): An unsigned integer that specifies the record type. MUST be 0x0805.

reserved (2 bytes): MUST be zero, and MUST be ignored.

A - fFile (1 bit): A bit that specifies that the query was generated from an import text file action. MUST be 1.

B - fDelimited (1 bit): A bit that specifies whether the data is delimited. MUST be a value from the following table:

Value	Meaning
0x0	The data fields are of fixed size.
0x1	The data is delimited.

C - iCpid (2 bits): An unsigned integer that specifies the code page used for the origin of the file. This value is unused when the value of the fUseNewiCpid field is equal to 1 and the value of the iCpidNew field is greater than 2. MUST be a value from the following table:

Value	Meaning
0x0	Macintosh
0x1	Windows (ANSI)
0x2	MS-DOS (PC-8)

D - fPromptForFile (1 bit): A bit that specifies whether a file name is prompted for on refresh. MUST be a value from the following table:

Value	Meaning
0x0	Saved file location is used during refresh
0x1	Prompt for file name on refresh

iCpidNew (10 bits): An unsigned integer that specifies application-specific code page information that can be used to optimize text importation and can be ignored.

E - fUseNewiCpid (1 bit): A bit that specifies whether the iCpidNew value is used for specifying the code page instead of the iCpid value.

unused1 (16 bits): Undefined and MUST be ignored.

rowStartAt (4 bytes): A signed integer that specifies the row in the source file where the query begins.

F - fTab (1 bit): A bit that specifies whether the tab character is treated as a column delimiter.

G - fSpace (1 bit): A bit that specifies whether the space character is treated as a column delimiter.

H - fComma (1 bit): A bit that specifies whether the comma character is treated as a field delimiter.

I - fSemiColon (1 bit): A bit that specifies whether the semi-colon character is treated as a column delimiter.

J - fCustom (1 bit): A bit that specifies whether the custom character defined in the chCustom field is treated as a column delimiter.

K - fConsecutive (1 bit): A bit that specifies whether consecutive delimiters are treated as one delimiter.

L - iTextDelm (2 bits): An unsigned integer that specifies a text delimiter. MUST be a value from the following table:

Value	Meaning
0x0	Quotation mark
0x1	Apostrophe
0x2	No text delimiter

chCustom (16 bits): An unsigned integer that specifies the custom delimiter Unicode character. This value is used if the fCustom value equals 1.

unused2 (8 bits): Undefined and MUST be ignored.

itwf (4 bytes): A signed integer that specifies the number of fields in each row of data. MUST be greater than 0 and less than or equal to 256.

chDecimal (1 byte): An unsigned integer that specifies the decimal separator. MUST be a character from the ANSI character set.

chThousSep (1 byte): An unsigned integer that specifies the thousands separator. MUST be a character from the ANSI character set.

rgtxtwf (variable): An array of TxtWf that specifies the text to column fields. The size of the array is determined by the itwf value. The array MUST NOT be empty.

rgchFile (variable): An XLUnicodeString structure that specifies the name of the text file that is the source of the query.