• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • paul wheaton
  • Ron McLeod
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:

Convert XML to Excel

 
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,


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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic