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

Versions Compared

Old Version 8

changes.mady.by.user Chris Peck [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Chris Peck [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.6.1

...

8.6.1
Description

Excerpt

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

Signature
C#
C#
public PivotTable CreateConsolidatedPivotTable(IEnumerable<Area> data, int row, int column)
{signature}
{signature:
}
Signature
vb.net
vb.net
Public Function CreateConsolidatedPivotTable(ByVal data As IEnumerable (of Area), ByVal row As Integer, ByVal column 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}
{remarks}This constructor will create Row, Column, and Value&nbsp;as&nbsp;?[EW8:SourceField]s. &nbsp;These&nbsp;?{{SourceFields}} will be created using the same algorithm that the Pivot Table Wizard in Excel uses to create Multiple Consolidation Pivot Tables.

{remarks}


{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.

Remarks

This constructor will create Row, Column, and Value as ?SourceFields.  These ?SourceFields will be created using the same algorithm that the Pivot Table Wizard in Excel uses to create Multiple Consolidation Pivot Tables.

Example
Code Block
csharp
csharp
titleC#

ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
Worksheet ws = wb.Worksheets[0];
List<Area> areas = new List<Area>();
Area data = ws.CreateArea(0, 0, 10, 10);
Area data2 = ws.CreateArea(12, 0, 5, 5);
areas.Add(data);
areas.Add(data2);
PivotTable pt = ws.PivotTables.CreateConsolidatedPivotTable(areas, 11, 11);
{code} {code:vbnet|title=
 Code Block
vbnet
vbnet
titlevb.net
}

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

{code}
{example}