Partager via


_QueryTable.WebSingleBlockTextImport Property

True if data from the HTML <PRE> tags in the specified Web page is processed all at once when you import the page into a query table. False if the data is imported in blocks of contiguous rows so that header rows will be recognized as such. The default value is False. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property WebSingleBlockTextImport As Boolean
    Get
    Set
'Usage
Dim instance As _QueryTable
Dim value As Boolean

value = instance.WebSingleBlockTextImport

instance.WebSingleBlockTextImport = value
bool WebSingleBlockTextImport { get; set; }

Property Value

Type: System.Boolean

Remarks

Use this property only when the query table’s QueryType property is set to xlWebQuery and the query returns an HTML document.

See Also

Reference

_QueryTable Interface

_QueryTable Members

Microsoft.Office.Interop.Excel Namespace