_QueryTable.WebPreFormattedTextToColumns Property
Returns or sets whether data contained within HTML <PRE> tags in the Web page is parsed into columns when you import the page into a query table. The default is True. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property WebPreFormattedTextToColumns As Boolean
Get
Set
'Usage
Dim instance As _QueryTable
Dim value As Boolean
value = instance.WebPreFormattedTextToColumns
instance.WebPreFormattedTextToColumns = value
bool WebPreFormattedTextToColumns { get; set; }
Property Value
Type: System.Boolean
Remarks
This property is used only when the QueryType property of the query table is xlWebQuery and the query returns an HTML document.