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

public PivotTable CreateConsolidatedPivotTable(IEnumerable<Area> data, int row, int column)

Public Function CreateConsolidatedPivotTable(ByVal data As IEnumerable (of Area), ByVal row As Integer, ByVal column As Integer) As PivotTable

The data that is represented within the PivotTable.

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

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

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.

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);

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);