_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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property TextFileFixedColumnWidths As Object
Get
Set
'Usage
Dim instance As _QueryTable
Dim value As Object
value = instance.TextFileFixedColumnWidths
instance.TextFileFixedColumnWidths = value
Object TextFileFixedColumnWidths { get; set; }
Property Value
Type: System.Object
Remarks
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.