• 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

Exporting Java to an Excell Document

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
To make a long story short, I have already designed an applet which functions correctly, but the people I designed it for asked if I could export the data from ti to a Microsoft excel document.
After Googling this, I found first Apache POI, Appache's library for this task, but I also found many other libraries which could accomplish the task.
Does anyone have any experience with these libraries? The most important thing for me now is to use the most efficient one (from the code writer's perspective). I don't want to get the program 90% done and then find out that it could have been done in 15 minutes if I had used a different API.

The only requirements is that it must be able to handle either the 97-2003 Microsoft excel format (.xls) or the new format (.xlsx) and it must be open source.

Thanks for the help,

R. Keane
 
Ranch Hand
Posts: 33
Google Web Toolkit Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
there is lot of library available as open source in JAVA.

like
1. APACHE POI
2. Java Excel library

I think Apache POI is good open source library. It will cover all feature of Excel.
 
R Keane
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
okay. thanks.

I wasn't sure if one was much better than the others or not, so I guess I will go with Apache POI.

 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We also have some information about this in our Accessing File Formats FAQ.
 
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I use Apache POI nearly everyday at work in both xls and xlsx formats.

If you have any glaring issues or question then let me know. The only limitations I've experiance with Apache POI is creating charts from scratch is not possible. Unless you import the data to an already existing spreadsheet with the chart already built and reference to a cell range.

 
You get good luck from rubbing the belly of a tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic