Thank you for your reply. However, I think it can't solve my problem. The data in the specific excel were integrated in a pivot table, and what I have to do is using JAVA or JSP to export data in that excel. I could not figure out another way to achieve my goal except changing condition fields in pivot table to get the wanted data. It seems that, it is possible to read from pivot table, though it is impossible to create one. Regards, Teddy
------------------ ???????? ------------------ ??????: "Mead Lai"<[email protected]>; ????????: 2012??12??6??(??????) ????1:36 ??????: "POI Users List"<[email protected]>; ????: Re: Reading pivot table https://poi.apache.org/spreadsheet/limitations.html here are some limitation of POI. Why not export the XLS into plain-txt file? Regards, Mead On Thu, Dec 6, 2012 at 1:24 PM, ?????????? <[email protected]> wrote: > pivot tables in .xls --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
