PHP export data to xls with pivot tables
excel, php, pivot-table
Solution
For an export to include pivot tables, you have precisely three options.
- Ilia Alshanetsky's Excel extension (xls only, and requires commercial component)
- PHP's COM extension (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)
- The Open Office alternative to COM (PUNO) (requires Open Office installed on the server with Java support enabled)
Problem
How can I export data in PHP to excel spreadsheet that also has pivot tables? Is there any good tutorial about it? Thanks