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