Wiki Markup |
---|
{introducedin: 8.6.1} {description} {excerpt} Creates a new PivotTable for multiple consolidated ranges. A PivotTable created by this method is part of {{[EW8:PivotTables]}} collection. {excerpt} {signature:C#} public PivotTable CreateConsolidatedPivotTable(IEnumerable<Area> data, int row, int column) {signature} {signature: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 as ?[EW8:SourceField]s. These ?{{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#} 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=vb.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} |
Page History
Overview
Content Tools