Mar 6, 2012 #1 drimades IS-IT--Management Nov 8, 2004 221 MK 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?
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?
Mar 7, 2012 #2 Diancecht Programmer Jan 8, 2004 4,042 ES You can just export is as a plain file with csv format that Excel will recognise an open or use and API like Java POI to create a regular Excel file. Cheers, Dian Upvote 0 Downvote
You can just export is as a plain file with csv format that Excel will recognise an open or use and API like Java POI to create a regular Excel file. Cheers, Dian
Mar 8, 2012 #3 TonHu Programmer Dec 13, 2001 1,292 NL As Dian said: http://poi.apache.org Upvote 0 Downvote
Mar 8, 2012 Thread starter #4 drimades IS-IT--Management Nov 8, 2004 221 MK SOLVED using Apache POI. Thanks! Upvote 0 Downvote