Java

save SQl query result into excel file

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

•

Join Date: Apr 2007

Posts: 4

Reputation: Dhanesh.M is an unknown quantity at this point

Solved Threads: 0

Dhanesh.M

Offline

Newbie Poster

save SQl query result into excel file

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

•

Join Date: Feb 2006

Posts: 2,448

Reputation: masijade has much to be proud of

Solved Threads: 261

masijade

Offline

Nearly a Posting Maven

Re: save SQl query result into excel file

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

•

Join Date: Nov 2004

Posts: 6,143

Reputation: jwenting is just really nice

Solved Threads: 213

jwenting

Offline

duckman

Re: save SQl query result into excel file

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.