Page History

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