Hi,
i'm triying to add columns to a pivot table in excel.
This is the code snippets:
XSSFPivotTable pivotTable = sheet.createPivotTable(new
AreaReference("A4:AA10"), new CellReference("A3"), wb.getSheet("EXAMPLES"));
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 11);
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 12);
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 13);
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 11);
// pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 12);
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 13);
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 11);
pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 12);
// pivotTable.addColumnLabel(DataConsolidateFunction.SUM, 13);
When I open generated excel in Microsoft Excel I have following error:
"Excel found unreadable content in '..xls' Do you want to recover...".
I get this error when I try to add third column; when I use two columns I
haven't problems
Any idea?
Excuse for my English.
________________________________
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise confidential information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
use of the e-mail by you is prohibited. Where allowed by local law, electronic
communications with Accenture and its affiliates, including e-mail and instant
messaging (including content), may be scanned by our systems for the purposes
of information security and assessment of internal compliance with Accenture
policy.
______________________________________________________________________________________
www.accenture.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
