We are currently using the Apache POI for generation of excel spreadsheets. Everything goes fine with around 10k records, but we get a memory issue once there are more records(and please dont ask me to increase the jvm args to increase the heap size
I have googled and found there are some performances issues with POI API.
I could not find any suggestion/info about other better api's. Please suggest if you know one.
Also I could see that there is a class HSSFSerializer which converts xml to excel but I could find the jar(on the cocoon & poi project) which contains it or any other example on how it may be used. Can you please let me know where i can find this.
Any help on this is appreciated
Thanks a lot.