Message-ID: <1101364977.8833.1711663809990.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8832_43125088.1711663809990" ------=_Part_8832_43125088.1711663809990 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Creates a new, blank PivotTable for the specified area. A PivotTable cre=
ated by this method is part of =
PivotTables
collection.
public PivotTable CreatePivotTable(Area data, int aRow, int aColumn)=20
Public Function CreatePivotTable(ByVal data As Area, ByVal aRow As Integer,= ByVal aColumn As Integer) As PivotTable=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
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