poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Woolsey <greg.wool...@gmail.com>
Subject Re: Pivot Table Support
Date Thu, 28 Jun 2018 01:51:51 GMT
There is very limited support for pivot tables yet in POI, as you've
found.  The avenues I can think of for you are:

1. compare before and after XLSX output (it's zipped XML files) to see what
Excel is doing, then replicate that in POI - not typically a simple task.

2. Start with a "template" file you create in Excel - not an Excel
Template, but a plain file with the pivot table defined how you want it.
Then instead of creating a new blank workbook in POI, open that one.
Populate your data, update any range references if needed, and write the
updated version to a new file/stream.

3. Submit a patch adding what you need to POI.  Always welcome and super
helpful for us and the rest of the community, but for something like this,
probably not a cost/benefit most employers would agree to.

I've done #2 many times for lots of different purposes, and a couple of
those involved pivot tables.  It worked great.  POI can read and write all
sorts of content it doesn't have a high-level API to manipulate, as long as
the file complies with the OOXML standard.

On Wed, Jun 27, 2018 at 3:38 PM George S. <georges@mhsoftware.com> wrote:

> I'm using POI 3.17 and I've got a basic Pivot table working. Right now,
> I have rows, and I'm summing a column.
> I'd like to add columns. E.G. one of my source data columns is a period
> label. For example, 2018-05 or 2018-07. I'd like each period to be
> grouped, and the sums broken out by the Row/Period Label.
> It doesn't seem like this is possible in 3.17. Is support for this in
> the 4.0 snapshot?
> If it is, could someone give me a hint to how to add the columns?
> If it's not, I can get by, because it's just them dragging a column
> heading into the Columns segment of the Pivot Table editor, but I
> thought I'd ask.
> BTW, this works REALLY well. I've always limited myself to CSV output,
> but the ability to create sheets is really cool!
> --
> George S.
> *MH Software, Inc.*
> Voice: 303 438 9585 <(303)%20438-9585>
> http://www.mhsoftware.com

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message