Pivot Table

[sannyodictajr]

Hello Sir/Maam,

I've already researched and read several forum threads regarding reading existing excel template with pivot table already in it, then afterwards filling up of the source, the pivot table already disappeared (threads since 2009 up to 3rd quarter of 2013).

Was this issue already solved?

Thank you in advance.

[sannyodictajr]

bump ~

[vlasvlasvlas]

bumping this also +1

[lusimeon]

+1

[cons0l3]

+1

[lioman]

same problem here. Pivot functionality is gone after PHPExcel save.

[ashokgharpankar]

I am facing same problem. Pivot tables getting disappeared. Does anyone has solution on this?

[MarkBaker]

Pivot Tables are not supported.... and until somebody writes a solution that doesn't result in corrupt files in the majority of cases, then that will remain the case.

[ashokgharpankar]

@MarkBaker Thanks for quick reply, So, PHPEXcel library does not support pivot tables then I need to find other alternative, isn't it?

[MarkBaker]

Good luck finding an alternative, I only know of three ways to handle pivot tables in PHP:

• 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)
• Ilia Alshanetsky's Excel extension now on github (requires commercial libXL component)

[lioman]

And there is apache-poi wich handles pivot tables in a limited way.

XSSF has limited support for creating Pivot Tables, and very limited read/change support.

But you can create a Excelpivot template and write your Raw data to a given sheet and this works quit nice. And If you use SXSSF you can write large data sets into a file

[Progi1984]

Sample base :

• https://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/CreatePivotTable.java
• https://dzone.com/articles/create-pivot-tables-pivot

[nadler]

In Perl you can extract the VB pivot code from an existing spreadsheet and inject that into a new one that you create. So by saving off the pivot ahead of time you can create a spreadsheet with a pivot table and data in one file from scratch.

I'm not sure if this would be a potential solution in the future with PHPExcel.

[csxcode]

same problem with me. Pivot table functionality from my template is gone after export.