|
From: Knepp, E. <eK...@c-...> - 2004-03-03 13:57:00
|
Sorry Philipp, Check this page out for how to utilize the POI API for spreadsheets. http://jakarta.apache.org/poi/hssf/quick-guide.html -Ethan -----Original Message----- From: Knepp, Ethan Sent: Wednesday, March 03, 2004 8:35 AM To: squ...@li... Subject: RE: [Squirrel-sql-users] Redirect output to file? Philipp, I encountered the same situation some months back. I solved my problem by writing some JAVA code that utilized Apache's POI API (allows you to create MS documents, spreadsheets, etc) to export the Result Set into an excel spreadsheet. I also modified the same code to allow the same Result Set to be exported as a csv file. Here is an quick example of how to use the POI API: http://jakarta.apache.org/poi/hssf/how-to.html Best Regards, Ethan -- Ethan Knepp -----Original Message----- From: Philipp K. Janert, Ph.D. [mailto:ja...@ie...] Sent: Friday, February 27, 2004 7:08 PM To: squ...@li... Cc: ja...@ie... Subject: [Squirrel-sql-users] Redirect output to file? Often, I use SQuirrel to interactively build up a query, which I then would like to run with the results being dumped into a file. I know that I can copy/paste the results out of the results window, but this is rather unpleasant if the resulting set is big. Best regards, Ph. -- Philipp K. Janert, Ph.D. http://www.beyondCode.org ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id56&alloc_id438&op=click _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
