Edit

Share via


PivotCache.QueryType Property

Definition

Indicates the type of query used by Microsoft Excel to populate the PivotTable cache.

public:
 property Microsoft::Office::Interop::Excel::XlQueryType QueryType { Microsoft::Office::Interop::Excel::XlQueryType get(); };
public Microsoft.Office.Interop.Excel.XlQueryType QueryType { get; }
Public ReadOnly Property QueryType As XlQueryType

Property Value

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.

Applies to