_QueryTable.TextFileFixedColumnWidths _QueryTable.TextFileFixedColumnWidths _QueryTable.TextFileFixedColumnWidths Property


Returns or sets an array of integers that correspond to the widths of the columns (in characters) in the text file that you’re importing into a query table. Valid widths are from 1 through 32,767 characters. Read/write Object.

 property System::Object ^ TextFileFixedColumnWidths { System::Object ^ get(); void set(System::Object ^ value); };
public object TextFileFixedColumnWidths { get; set; }
Public Property TextFileFixedColumnWidths As Object

Property Value


Use this property only when your query table is based on data from a text file (with the QueryType property set to xlTextImport), and only if the value of the TextFileParseType property is xlFixedWidth.

You must specify a valid, nonnegative column width. If you specify columns that exceed the width of the text file, those values are ignored. If the width of the text file is greater than the total width of columns you specify, the balance of the text file is imported into an additional column.

Applies to