_QueryTable.WebConsecutiveDelimitersAsOne Property
True if consecutive delimiters are treated as a single delimiter when you import data from HTML <PRE> tags in a Web page into a query table, and if the data is to be parsed into columns. False if you want to treat consecutive delimiters as multiple delimiters. The default value is True. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property WebConsecutiveDelimitersAsOne As Boolean
Get
Set
'Usage
Dim instance As _QueryTable
Dim value As Boolean
value = instance.WebConsecutiveDelimitersAsOne
instance.WebConsecutiveDelimitersAsOne = value
bool WebConsecutiveDelimitersAsOne { get; set; }
Property Value
Type: System.Boolean
Remarks
Use this property only when the query table’s QueryType property is set to xlWebQuery, the query returns an HTML document, and the WebPreFormattedTextToColumns property is set to True.