search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.19k forks source link

Pivot Table #313

Open sannyodictajr opened 10 years ago

sannyodictajr commented 10 years ago

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 commented 10 years ago

bump ~

vlasvlasvlas commented 9 years ago

bumping this also +1

lusimeon commented 9 years ago

+1

cons0l3 commented 9 years ago

+1

lioman commented 8 years ago

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

ashokgharpankar commented 8 years ago

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

MarkBaker commented 8 years ago

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 commented 8 years ago

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

MarkBaker commented 8 years ago

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

lioman commented 8 years ago

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 commented 8 years ago

Sample base :

nadler commented 8 years ago

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 commented 6 years ago

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