0 out of 2 rated this helpful - Rate this topic

PivotTable Interface

Office 2003

Office 2010

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

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

Syntax

C++

public interface PivotTable

public interface PivotTable

JScript

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

Reference

Microsoft.Office.Interop.Excel Namespace

Other Resources

PivotTable Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD