File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exporting Java to an Excell Document

 
R Keane
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • 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
 
Ganesh Shirsat
Ranch Hand
Posts: 33
Google Web Toolkit Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • 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.

 
Jesper de Jong
Java Cowboy
Saloon Keeper
Pie
Posts: 15150
31
Android IntelliJ IDE Java Scala Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We also have some information about this in our Accessing File Formats FAQ.
 
Joshua Barrett
Greenhorn
Posts: 27
  • 0
  • Mark post as helpful
  • send pies
  • 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.

 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic