PivotCache.QueryType Property
Indicates the type of query used by Microsoft Excel to populate the PivotTable cache.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property QueryType As XlQueryType
Get
'Usage
Dim instance As PivotCache
Dim value As XlQueryType
value = instance.QueryType
XlQueryType QueryType { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlQueryType
Remarks
XlQueryType can be one of the following XlQueryType constants:
xlTextImport. Based on a text file; for query tables only.
xlOLEDBQuery. Based on an OLE DB query, including OLAP data sources.
xlWebQuery. Based on a Web page; for query tables only.
xlADORecordset. Based on an ADO recordset query.
xlDAORecordSet. Based on a DAO recordset query; for query tables only.
xlODBCQuery. Based on an ODBC data source.
You specify the data source in the prefix for the Connection property’s value.