Re: Read XSSFPivotTable to chart

2017-06-02 Thread Greg Woolsey
There is currently no api for creating charts. As someone working with reading charts with POI, I can say it will be a major undertaking to create from scratch. You might find it easier to start with a template workbook with a chart defined in Open Office or Excel, and then just edit the data wit

Read XSSFPivotTable to chart

2017-06-02 Thread Jonathan Ortiz
Hi, I have created a Excel Pivot Table XSSFPivotTable: //Configure the pivot table String area="A1:I"+last_row; AreaReference ar = new AreaReference(area); CellReference cr = new CellReference("A1");