Screen capture of pivot table with data as originally formatted in the file
Figure 2 shows an empty pivot table with the PivotTable toolbar floating over the window.
The Excel pivot table was correctly created so a PivotTable toolbar displays over the window.
It then prints the pages for the data, then for the pivot table, then for the footer.
To be honest, I don't know why so much XML code is required for the definition of the pivot table.
But the nice thing is that you can create the pivot table in Excel, save it as XML, and then use that XML code as a template for your own code.
Starting to build pivot tables with advanced Excel export with PHP
You can then create charts, data pivot tables, and so forth with the new spreadsheet.
In this article, I show you how to use one of the more advanced features, pivot tables, as an example of the potential for Excel export.
