Partager via

PivotCache Members

  • Article

Include Protected Members
Include Inherited Members

Represents the memory cache for a PivotTable report.

The PivotCache type exposes the following members.

Properties

  Name Description
Public property ADOConnection Returns an ADO connection object if the PivotTable cache is connected to an OLE DB data source.
Public property Application Returns an Application object that represents the Microsoft Excel application.
Public property BackgroundQuery True if queries for the PivotTable report or query table are performed asynchronously (in the background).
Public property CommandText Returns or sets the command string for the specified data source.
Public property CommandType Returns or sets a constant describing the value type of the CommandText property. The default value is xlCmdSQL.
Public property Connection Returns or sets connection information for a PivotTable cache.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created.
Public property EnableRefresh True if the PivotTable cache or query table can be refreshed by the user. The default value is True.
Public property Index Returns the index number of the object within the collection of similar objects.
Public property IsConnected Returns True if the MaintainConnection property is True and the PivotTable cache is currently connected to its source. Returns False if it is not currently connected to its source.
Public property LocalConnection Returns or sets the connection string to an offline cube file.
Public property MaintainConnection True if the connection to the specified data source is maintained after the refresh and until the workbook is closed. The default value is True.
Public property MemoryUsed Returns the amount of memory in bytes currently being used by the object.
Public property MissingItemsLimit Returns or sets the maximum quantity of unique items per PivotTable field that are retained even when they have no supporting data in the cache records.
Public property OLAP Returns True if the PivotTable cache is connected to an Online Analytical Processing (OLAP) server.
Public property OptimizeCache True if the PivotTable cache is optimized when it’s constructed. The default value is False.
Public property Parent Returns the parent object for the specified object.
Public property QueryType Indicates the type of query used by Microsoft Excel to populate the PivotTable cache.
Public property RecordCount Returns the number of records in the PivotTable cache or the number of cache records that contain the specified item.
Public property Recordset Returns or sets a Recordset object that’s used as the data source for the specified query table or PivotTable cache.
Public property RefreshDate Returns the date on which the PivotTable cache was last refreshed.
Public property RefreshName Returns the name of the person who last refreshed the PivotTable cache.
Public property RefreshOnFileOpen True if the PivotTable cache is automatically updated each time the workbook is opened. The default value is False.
Public property RefreshPeriod Returns or sets the number of minutes between refreshes.
Public property RobustConnect Returns or sets how the PivotTable cache connects to its data source.
Public property SavePassword True if password information in an ODBC connection string is saved with the specified query. False if the password is removed.
Public property SourceConnectionFile Returns or sets a String indicating the Microsoft Office Data Connection file or similar file that was used to create the PivotTable.
Public property SourceData Returns the data source for the PivotTable report.
Public property SourceDataFile Returns a String indicating the source data file for the cache of the PivotTable.
Public property SourceType Returns a value that identifies the type of item being published.
Public property Sql Reserved for internal use.
Public property UpgradeOnRefresh Contains information on whether to upgrade the PivotCache and all connected PivotTables on the next refresh. Read/write.
Public property UseLocalConnection True if the LocalConnection property is used to specify the string that enables Microsoft Excel to connect to a data source. False if the connection string specified by the Connection property is used.
Public property Version Returns the version of Microsoft Excel in which the PivotCache was created. Read-only.
Public property WorkbookConnection Establishes a connection between the current workbook and the PivotCache object. Read-only.

Top

Methods

  Name Description
Public method CreatePivotTable Creates a PivotTable report based on a PivotCache object.
Public method MakeConnection Establishes a connection for the specified PivotTable cache.
Public method Refresh Updates the cache of the PivotTable object.
Public method ResetTimer Resets the refresh timer for the specified PivotTable report to the last interval you set using the RefreshPeriod property.
Public method SaveAsODC Saves the PivotTable cache source as a Microsoft Office Data Connection file.

Top

See Also

Reference

PivotCache Interface

Microsoft.Office.Interop.Excel Namespace