Feature request: Any plan to support pivot table?

[calfzhou]

Do you have any plan to support Excel pivot table and pivot chart? I didn't find it in the document.

[jmcnamara]

I would like to add Pivot Tables and now that most other features are in place it is one of the most commonly requested features.

However, it is quite complex and has a data cache file that is hard to replicate.

I'll leave this open as a feature request and if I make some progress I'll post an update.

[Zenadix]

Have you made any progress on this?

[jmcnamara]

Have you made any progress on this?

Unfortunately no.

[ahmedelz]

Hi John, any progress on this feature request? I had to implement my scripts using pythonwin due to lack of pivot support in XlsxWriter. I'd like to be able to port the scripts to non Windows platforms but stuck at the moment.

[jmcnamara]

Progress update:

A few months ago I looked at this once more to see if it would be feasible to implement Pivot Tables (I had initially looked at this over a year ago).

My conclusions were:

• This is a very difficult task to do correctly.
• There would be several months work involved.
• It would require a very large number of test cases.
• The API would be difficult to define since Pivot Table have such a large number of features. (There is a reason that Excel has built-in helpers for Pivot Tables).

So, in summary, it is unlikely that this will be implemented.

John

[probonopd]

I would also be interested in Pivot tables.

[mooreed]

For pre-computed pivot tables, I use pandas to materialize the view, and for excel pivots, I have skated by with labels hinting to the user that the "large table" is ready for their making a the pivot table.

[probonopd]

Sorry I do not fully understand your previous comment. Does this mean that you are working on pivot table support? How can I create a pivot table programmatically?

[jmcnamara]

For the reasons stated above this won't be implemented. Closing.

[yugawara]

I'm curious, do other open source projects such as Apache POI support creating pivot tables in XLSX files?

[jmcnamara]

I'm curious, do other open source projects such as Apache POI support creating pivot tables in XLSX files?

The Ruby Axlsx module supports pivot tables but when I tried it a few year ago I couldn't get them to work.

I'm not aware of other options but I haven't looked extensively.

[yugawara]

Hi John,

I see, oh btw, thank you so much for xlsxwiter - I have been using it everywhere at commercial projects I have been employed at :-)

When I was writing a wrapper for the library for the current project, I noticed that Pivot table feature is missing.

I have been also studying Haskell so maybe I will do what you tried with Ruby using Haskell.

If I crack it during weekend (being a DIY guy the time is hard to come by though...) I will submit the code :-)

Cheers, Yasu

On 18 Nov 2017, at 04:33, John McNamara notifications@github.com wrote:

I'm curious, do other open source projects such as Apache POI support creating pivot tables in XLSX files?

The Ruby Axlsx module supports pivot tables but when I tried it a few year ago I couldn't get them to work.

I'm not aware of other options but I haven't looked extensively.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[pkanavos]

FYI EPPlus supports Pivot Tables since at least 2012. Judging from the number of files, it's certainly not trivial.

[siva1b3]

Hi John,

Thank you so much for xlsxwiter.