Is it possible to read from a pivot table using java program?

Question

I would like to know if it's possible to read the pivot table using any existing APIs such as POI. I know there are some limitations regarding reading / changing the values of the cell, but I want to know at which extent we can read the sub content of the cell?

Has anyone tried this before? Are the documentations of POI V3.13 updated on this topic?

I see a lot of questions about pivot table creation, but not reading.

Thanks for your help.

IceArdor · Accepted Answer · 2016-03-20 06:55:50Z

1

You can read existing PivotTables in XLSX workbooks using XSSFSheet.getPivotTables().

If the XSSFPivotTable class doesn't have the methods you need, consider developing the functionality that you need and contribute back the patches for the new code, unit tests, example code, and/or documentation.

The latest documentation is generated from the trunk.

answered Mar 20, 2016 at 6:55

IceArdor

2,05122 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to read from a pivot table using java program?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related