SQL Query resultset into Excel Sheet

[chandpuri]

Dear all,
I am very new to java and am writing a program to put the resultset from an SQL query into an excel sheet. I already have downloaded the library jexcelapi library.
Please let me know how could I proceed further on this. It would be great if someone could give me a sample code to see.
Thanks a ton.

Cheers
Chandpuri

[chandpuri]

Hi guys,
I dont believe that no one has any clue on writing recordsets into excel from SQL using Java.
I thought there were good knowledgable people.
Cmon guys

Best Regards,
G

[jelly]

If you have downloaded JExcelApi then there are whole set of demos included, try working your way through the write one - it is comprehensive. Be aware that JExcelApi does not support xslx files i.e. the latest version of excel. If you simply want to get data from a result set into excel then create a .csv file, make the first row your column headers and and each other row the data; excel will open it drectly and convert it on the fly. For example a result with two rows, each row has three columns - age, town, country . Create a csv file that looks something like the following from the data:

Code:

age, town, country
42, london, uk
19, glasgow, scotland

[ad1234]

Did u made any progress ?

I am working on same thing and thought if you can guide !