Replies: 3 comments
-
See #261 |
Beta Was this translation helpful? Give feedback.
-
Has anyone created a fork that implements pivot tables? Or is anyone able/interested in doing so as a paid project? I too am interested in commissioning or adding support for pivot tables to exceljs. Defining and calculating the cache seems to be the major complication. It looks like exceljs would have to calculate the entire pivot table to write the results in both the worksheet and pivot table cache. My big question is whether it is necessary to calculate all the cached content or whether we can just save the definitions and Excel then calculates the pivot table on open (possibly by right clicking the pivot table in Excel GUI and clicking 'Refresh'). I experimented by selectively removing cached content and re-zipping the file but it appears that everything needs to be retained or excel Excel either complains on opening or the results that appear on opening don't reflect the source data.
|
Beta Was this translation helpful? Give feedback.
-
See comment #2293 (comment) for a way to add simple pivot tables. |
Beta Was this translation helpful? Give feedback.
-
Hello,
I'm currently using the lib to generate files through a dockerized API node server (with templating system, ...).
I would like to be able to include tab with pivot table but, as mentioned in the documentation, it's not supported yet.
It would be perfect if I could merge a tab from an .xlsx file (ie. my template), containing the pivot table, without breaking everything.
I don't need to modify this pivot table with exceljs, just duplication.
Is there currently any way to do that ?
If this is not the case I'll be glad to help by contributing on this project, and any tips on how to do that will be appreciated.
Beta Was this translation helpful? Give feedback.
All reactions