Thread: [Squirrel-sql-users] Creating Excel documents from Squirrel
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: CptBlaubaer <cpt...@gm...> - 2006-12-08 09:03:04
|
Hi there, perhaps we could expand the possibilities of the CSV export a bit by creating "real" Excel documents. I've been playing around with the POI project (http://jakarta.apache.org/poi/) and created a function that takes a JDBC ResultSet and the belonging ResultSetMetaData to create an Excel sheet from it. That gives the opportunity to keep the meta-data-information about data-types and format the Excel-Cells in a proper way. Since I'm not a Java or Eclipse-Guru I would need some help with how to integrate the POI ressorces into SQuirreL, if some of you guys might find the feature of a direct Excel export interesting. Next step might also be doing the thing vice-versa, so creating database tables from Excel-sheets. I'd be happy to help extend the capabilities of SQuirreL which has become one of my favourite tools. Have a nice weekend Take care Andreas |