OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 11

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version 12

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Introducedin
8.4

...

8.4
Description

Excerpt

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

Signature
C#
C#
public PivotTable CreatePivotTable(Area data, int aRow, int aColumn)
{signature}
{signature:
}
Signature
vb.net
vb.net
Public Function CreatePivotTable(ByVal data As Area, ByVal aRow As Integer, ByVal aColumn As Integer) As PivotTable
{signature}

{parameters}
{param:data}
The data that is represented within the PivotTable.
{param}
{param:aRow}
The 0-based number of the row of the upper left corner of the PivotTable.
{param}
{param:aColumn}
The 0-based number of the column of the upper left corner of the PivotTable.
{param}

{example}
{code:csharp|title=C#}
Parameters
Param
data
data

The data that is represented within the PivotTable.

Param
aRow
aRow

The 0-based number of the row of the upper left corner of the PivotTable.

Param
aColumn
aColumn

The 0-based number of the column of the upper left corner of the PivotTable.

Example
Code Block
csharp
csharp
titleC#

ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
          Worksheet ws = wb.Worksheets[0];
          Area data = ws.CreateArea(0, 0, 10, 10);
          PivotTable pt = ws.PivotTables.CreatePivotTable(data, 11, 11);
{code} {code:
 Code Block
vb.net
|title=
vb.net
titlevb.net
}

Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx")
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim data As Area = ws.CreateArea(0, 0, 10, 10)
          Dim pt As PivotTable = ws.PivotTables.CreatePivotTable(data, 11, 11);

{code}

{example}