File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes Exporting Data into the Excel sheet 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 Data into the Excel sheet" Watch "Exporting Data into the Excel sheet" New topic

Exporting Data into the Excel sheet

R . Ravi Kumar

Joined: Sep 25, 2004
Posts: 6

I need help in Exporting the data into an Excelsheet through java. Anyone having idea respond immediately.

Jeroen Wenting
Ranch Hand

Joined: Oct 12, 2000
Posts: 5093
Originally posted by R . Ravi Kumar:
Anyone having idea respond immediately.

hmm, maybe let him wait a year or so.

Edward Kenworthy
Ranch Hand

Joined: Oct 05, 2003
Posts: 66
Hi Ravi

Export it as CSV (comma separated values): it's easy to generate in Java and Excel will happily import it.



My rate for responding immediately is 250GBP per hour or part, minimum 3 hours. Please let me know if you require this premium service in future and we can arrange contracts.
David Ulicny
Ranch Hand

Joined: Aug 04, 2004
Posts: 724
I'm late but this will help you

SCJP<br />SCWCD <br />ICSD(286)<br />MCP 70-216
Dave Mace

Joined: Jan 04, 2005
Posts: 11
POI can be handy for writing Excel documents. It has some functionality with Word .doc files as well if you're interested, but that part of the api is not quite up-to-snuff yet. Their priority seems to reside with Excel which is where most of the interest probably is anyways.


Dad always thought laughter was the best medicine, which I guess is why several of us died of tuberculosis. -Jack Handy
Ryan Bailey
Ranch Hand

Joined: Feb 26, 2002
Posts: 134
If you need to do formating within excel I would recommend the POI API that is provided by Jakarta. I used it on my last assignment, but be careful. There are still a couple bugs in it. One of the problems that I noticed is if I user were to scroll thru blank cells in the excel spreadsheet with the cursor, the API would bomb out because of null reasons. You would of thought they would of checked for null values. I would always have to highlight blank cells and delete them in order for my processing to work. The CSV appoach works great too if you do not intend to do any formatting with the excel spreadsheet.

Good luck,

Java: The power, elegance, and simplicity of a hand grenade
Mark Vedder
Ranch Hand

Joined: Dec 17, 2003
Posts: 624

There is also a Java Excel API available under the GNU Lesser General Public License. It provides the ability to read, write and modify Excel spreadsheets.
I agree. Here's the link:
subject: Exporting Data into the Excel sheet
It's not a secret anymore!