Support for Pivot Tables #894

New Issue

2017-11-20T10:10:28Z

sathish804 commented

2017-11-20 10:10:28 +00:00

(Migrated from github.com)

Dear SheetJS,

Please add the support for Pivot Tables reading and writing from a existing xlsx or xlsm file.

Regards,
Sathish

Dear SheetJS, Please add the support for Pivot Tables reading and writing from a existing xlsx or xlsm file. Regards, Sathish

sathish804 commented

2017-11-23 14:32:12 +00:00

(Migrated from github.com)

Dear SheetJS,

I was trying to experiment with parsing of the Pivot tables I was able to parse the pivot data needed as shown in the screen shot.

I was checking the relations to write for the pivot data.
I wrote the pivotCache, pivotTables and _rels files for the 2 folders.
I updated the code to write the pivot information into workbook.xml and [Content_Types].xml.

When I looked into the extracted content of the workbook generated I don't see any difference between them but I was getting excel work book corrupted issue and on opening pivotTable xml files are deleted.

Find the attached Input file and output file generated.

Could you please help me to find what went wrong?

2.zip

Regards,
Sathish.

![image](https://user-images.githubusercontent.com/14090242/33177351-a01afc18-d062-11e7-83b6-088c502ad06e.png) Dear SheetJS, I was trying to experiment with parsing of the Pivot tables I was able to parse the pivot data needed as shown in the screen shot. I was checking the relations to write for the pivot data. I wrote the pivotCache, pivotTables and _rels files for the 2 folders. I updated the code to write the pivot information into workbook.xml and [Content_Types].xml. When I looked into the extracted content of the workbook generated I don't see any difference between them but I was getting excel work book corrupted issue and on opening pivotTable xml files are deleted. Find the attached Input file and output file generated. Could you please help me to find what went wrong? [2.zip](https://github.com/SheetJS/js-xlsx/files/1499510/2.zip) Regards, Sathish.

Sign in to join this conversation.