Message-ID: <1356990582.2453.1710838411983.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2452_14008015.1710838411983" ------=_Part_2452_14008015.1710838411983 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html PivotTables

PivotTables

Introduced in build 8.4

=20

Description

The=20 PivotTables collection represents the set of PivotTables = in a worksheet. To return a PivotTables collection, use=20 Worksheet.PivotTables.=20
C#
=20
[DefaultMember("Item")]
 public sealed class PivotTables: System.Collections.Generic.IEnumerable<=
;PivotTables>
=20
=20
vb.net
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class PivotTables
=09=09Implements System.Collections.Generic.IEnumerable(Of PivotTable)
=20

Properties

Name

Description

C= ount

Returns the number of PivotTables in the workshe= et.

Indexers

Name

Description

Item(Int32)

Returns the PivotTable at the specified 0-based position in the PivotTables collection.

Item(String)

Returns the PivotTable with the specified name in the PivotTables collection.

Methods

Name

Description

CreatePivotTable(Area, Int32, Int32)

Creates a new, blank PivotTable for the spec= ified area. A PivotTable created by this method is part of PivotTables collection.

CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)

Creates a new PivotTable for multiple consol= idated ranges. A PivotTable created by this method is part of PivotTables collection.

GetEnumerator()

Returns an IEnumerator for the PivotTables in a = Worksheet .
------=_Part_2452_14008015.1710838411983--