Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exporting Data into the Excel sheet

 
R . Ravi Kumar
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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


Regards,
Ravi.
 
Jeroen Wenting
Ranch Hand
Posts: 5093
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by R . Ravi Kumar:
Anyone having idea respond immediately.


hmm, maybe let him wait a year or so.
 
Edward Kenworthy
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 724
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm late but this will help you
http://jakarta.apache.org/poi/
 
Dave Mace
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ryan Bailey
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Mark Vedder
Ranch Hand
Posts: 624
IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic