Message-ID: <1787819177.2579.1710845389440.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_2578_1519966442.1710845389440" ------=_Part_2578_1519966442.1710845389440 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html PivotTables.CreatePivotTable(Area, Int32, Int32)

PivotTables.CreatePivotTable(Area, Int32, Int32)

Introduced in build 8.4

= =20

Descr= iption

=20

Creates a new, blank PivotTable for the specified area. A PivotTable cre= ated by this method is part of P= ivotTables collection.

=20
C#
=20
public PivotTable CreatePivotTable(Area data, int aRow, int aColumn)
=20
=20
vb.net
=20
Public Function CreatePivotTable(ByVal data As Area, ByVal aRow As Integer,=
 ByVal aColumn As Integer) As PivotTable
=20
=20

Parame= ters

=20
data
Th= e data that is represented within the PivotTable.=20
aRow
Th= e 0-based number of the row of the upper left corner of the PivotTable.=20
aColumn The 0-based number of the column of the upper left corner of the PivotT= able.=20

Examples=

=20
C#
=20
ExcelApplication xla =3D new ExcelApplication();
          Workbook wb =3D xla.Open(@"C:\MySpr=
eadsheet.xlsx");
          Worksheet ws =3D wb.Worksheets[0];
          Area data =3D ws.CreateArea(0, 0, 10, 10=
);
          PivotTable pt =3D ws.PivotTables.CreatePivotTable(data, 11, 11);
=20
=20
vb.net
=20
Dim xla As New ExcelApplication()
          Dim wb As Workbook =3D xla.Open("C:=
\MySpreadsheet.xlsx")
          Dim ws As Worksheet =3D wb.Worksheets(0)
          Dim data As Area =3D ws.CreateArea(0, 0, 10, 10)
          Dim pt As PivotTable =3D ws.PivotTables.CreatePivotTable(data, 11=
, 11);
=20
------=_Part_2578_1519966442.1710845389440--