.
| Note |
|---|
The instructions on this page apply for using PivotTables with ExcelWriter 7.5 and earlier. If you are using ExcelWriter 7.6 or later please use the instructions on Templates and Pivot Tables |
A PivotTable report is an interactive table which allows the user to have multiple views of data. By changing the view, the PivotTable report can show different summaries of the data or drill down to display more details for particular areas. ExcelWriter allows you to include PivotTables in an ExcelWriter template file. If there are PivotTables in the original template file, they will be preserved when the template is processed using ExcelWriter.
There are specific guidelines you must follow when creating a template file for bringing data into PivotTables using ExcelTemplate.
| Note |
|---|
When using the ExcelApplication object to modify an existing spreadsheet, the following steps are not required; these steps are necessary only when opening a file containing data markers (i.e. an ExcelWriter template). |
...