.
...
| Code Block |
|---|
ExcelApplication xla = new ExcelApplication();
//Example.xlsx has a worksheet 'Data' with 9 columns and 244 rows of data
Workbook wb = xla.Open("\\BasicExample.xlsx");
Worksheet data_ws = wb.Worksheets["Data"];
Worksheet pivot_ws = wb.Worksheets.CreateWorksheet(["Pivot")];
|
This example places the PivotTable on a separate sheet. It is recommended that each PivotTable be placed on a separate sheet.
...