Thread: Exporting recordset to xls spreadsheet

I'm using Netbeans to create db application. I need to export the results of a query (recordset) into an excel file.
How can I do that?
Here is how I create the recordset:

String host = "jdbc:derby://localhost:1527/TownHall";
        String uName = "test";
        String uPass= "111";
        try{
        Connection con = DriverManager.getConnection( host, uName, uPass );
        Statement stmt = con.createStatement( );
        String SQL = "SELECT * FROM TAXES";
        ResultSet rs = stmt.executeQuery( SQL );

Read through this JExcelApi

Originally Posted by copeg

...or read through this: Apache POI - the Java API for Microsoft Documents

I'm not able to find the relevant POI jar file. Any help?