This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Java in General and the fly likes Exporting Java to an Excell Document Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Exporting Java to an Excell Document" Watch "Exporting Java to an Excell Document" New topic

Exporting Java to an Excell Document

R Keane

Joined: Jan 22, 2011
Posts: 5
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

Joined: Jan 10, 2010
Posts: 33

there is lot of library available as open source in JAVA.

2. Java Excel library

I think Apache POI is good open source library. It will cover all feature of Excel.
R Keane

Joined: Jan 22, 2011
Posts: 5
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

Joined: Aug 16, 2005
Posts: 15100

We also have some information about this in our Accessing File Formats FAQ.

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Joshua Barrett

Joined: Sep 08, 2010
Posts: 27
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:
subject: Exporting Java to an Excell Document
It's not a secret anymore!