save SQl query result into excel file

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site
Reply

Join Date: Apr 2007
Posts: 4
Reputation: Dhanesh.M is an unknown quantity at this point 
Solved Threads: 0
Dhanesh.M's Avatar
Dhanesh.M Dhanesh.M is offline Offline
Newbie Poster

save SQl query result into excel file

 
0
  #1
May 18th, 2007
I want to store the results generated out of SQL query into excel file ...
how do I go about doing it?
help
Reply With Quote Quick reply to this message  
Join Date: Feb 2006
Posts: 2,448
Reputation: masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of masijade has much to be proud of 
Solved Threads: 261
Moderator
masijade's Avatar
masijade masijade is offline Offline
Nearly a Posting Maven

Re: save SQl query result into excel file

 
0
  #2
May 18th, 2007
Read up on JDBC, first (the Sun tutorials are enough).

Then download, read the documentation for, and experiment with, either POI or JExcel.

Then, combine the lessons learned from the two above points.
Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Reply With Quote Quick reply to this message  
Join Date: Nov 2004
Posts: 6,143
Reputation: jwenting is just really nice jwenting is just really nice jwenting is just really nice jwenting is just really nice 
Solved Threads: 213
Team Colleague
jwenting's Avatar
jwenting jwenting is offline Offline
duckman

Re: save SQl query result into excel file

 
0
  #3
May 18th, 2007
or write your own code to write out SLK...
Not the nicest code to look at, but you loose dependencies on another few external libraries which may be worth it.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



Tag cloud for Java
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC