• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Bear Bibeault
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • salvin francis
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Frits Walraven
Bartenders:
  • Jj Roberts
  • Carey Brown
  • Scott Selikoff

Exporting Data into the Excel sheet

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 5093
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm late but this will help you
http://jakarta.apache.org/poi/
 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 624
IntelliJ IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ever since I found this suit I've felt strange new needs. And a tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic