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:
Code :
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 );
Re: Exporting recordset to xls spreadsheet
Read through this JExcelApi
Re: Exporting recordset to xls spreadsheet
Re: Exporting recordset to xls spreadsheet
Re: Exporting recordset to xls spreadsheet
Quote:
Originally Posted by
copeg
I'm not able to find the relevant POI jar file. Any help?