How can I export data in PHP to excel spreadsheet that also has pivot tables? Is there any good tutorial about it? Thanks
如何将PHP中的数据导出到也具有数据透视表的Excel电子表格？关于它有什么好的教程吗？谢谢
1 个解决方案
#1
6
For an export to include pivot tables, you have precisely three options.
对于包含数据透视表的导出，您有三个选项。
- Ilia Alshanetsky's Excel extension (xls only, and requires commercial component)
- Ilia Alshanetsky的Excel扩展（仅限xls，需要商业组件）
- PHP's COM extension (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)
- PHP的COM扩展（需要启用COM的电子表格程序，例如在服务器上运行的MS Excel或OpenOffice Calc）
- The Open Office alternative to COM (PUNO) (requires Open Office installed on the server with Java support enabled)
- Open Office替代COM（PUNO）（需要在启用了Java支持的服务器上安装Open Office）
#1
6
For an export to include pivot tables, you have precisely three options.
对于包含数据透视表的导出，您有三个选项。
- Ilia Alshanetsky's Excel extension (xls only, and requires commercial component)
- Ilia Alshanetsky的Excel扩展（仅限xls，需要商业组件）
- PHP's COM extension (requires a COM enabled spreadsheet program such as MS Excel or OpenOffice Calc running on the server)
- PHP的COM扩展（需要启用COM的电子表格程序，例如在服务器上运行的MS Excel或OpenOffice Calc）
- The Open Office alternative to COM (PUNO) (requires Open Office installed on the server with Java support enabled)
- Open Office替代COM（PUNO）（需要在启用了Java支持的服务器上安装Open Office）