File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Exporting Data into the Excel sheet" Watch "Exporting Data into the Excel sheet" New topic
Author

Exporting Data into the Excel sheet

R . Ravi Kumar
Greenhorn

Joined: Sep 25, 2004
Posts: 6
Hi,

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


Regards,
Ravi.
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.


42
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.

Edward

PS

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
http://jakarta.apache.org/poi/


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

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.

David


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,
Ryan


SCJP 1.4, SCWCD
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Exporting Data into the Excel sheet
 
Similar Threads
save a report as an excel file
export a data file
help me Xsl in struts2?
Export Query to Excel for ORACLE
Excel Float value problem