Share via


PivotTable Interface 

Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Usage

Public Class ivotTableImplementation
    Implements PivotTable
End Class
Dim ivotTableImplementation1 As New ivotTableImplementation()

Syntax

Public Interface PivotTable
public interface PivotTable
public interface class PivotTable
public interface PivotTable
public interface PivotTable

Remarks

Use PivotTables(index), where index is the PivotTable index number or name, to return a single PivotTable object.

Because PivotTable report programming can be complex, it’s generally easiest to record PivotTable report actions and then revise the recorded code. To record a macro, point to Macro on the Tools menu and then click Record New Macro.

Platforms

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace

Other Resources

PivotTable Members