• 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:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Excel and Word from java

 
Ranch Hand
Posts: 388
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi
i'll have to create MS WORD and MS EXCEL documents from a java app (the 2000 versions, if possible).
a quick search lead me to apaches POI.
anybody here who is using this ?
is it good, stable, has all the features required, does it come in a nice box :-)
what is your oppinion ?
any other products i should consider ? (commercial/non commercial. pure java (no dll as jacob))
thanks
k
 
Ranch Hand
Posts: 529
C++ Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am using POI in a project right now to access and write to xls files. So far, I have no complaints. The API is very thorough and easy to use.
Barry
 
karl koch
Ranch Hand
Posts: 388
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi barry
does POI support charts ? i think i read it does not yet.
the reports i need to create are quite easy
just some numbers i get out of the DB, no calculations on the excel side. for the numbers, normally, i need to create a chart (bar, pie, line...whatever user wants).
thanks,
karl
 
Barry Andrews
Ranch Hand
Posts: 529
C++ Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hmmmm... Not sure about charts. I have not had to use them. There is a ChartRecord class in the org.apache.poi.hssf.record package, but I'm not sure if that's what you want. Maybe check out the javadocs and see: http://jakarta.apache.org/poi/javadocs/
Good luck!
Barry
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic