> In terms of the CSV and SQL bits, it's possible that we'd be better off >looking at somethingl like Apache Cocooon to do the transformations for >these. >It's quite likely that we'd need to do a few tweaks to the POI Excel output >types (not sure how much love they've had lately), but that could deliver a >wide range of inputs very easily. The excel ant step could then just be >configuring up a cocoon pipeline based on the options given in ant, rather >than >having to do loads of other coding too!
I still don't see it. Reading the tutorials for Cocoon, it seems like this for XML transformation, how would that apply to CSV and SQL results? Are the Cocoon bindings for these types of things to create XML? Thanks in advance for clarifying. Jon ________________________________ From: Nick Burch <nick.bu...@alfresco.com> To: POI Developers List <dev@poi.apache.org> Sent: Tue, July 12, 2011 4:29:16 PM Subject: Re: Proposed Enhancements to ExcelAnt On Sun, 10 Jul 2011, Jon Svede wrote: > I am thinking about extending the ExcelAnt framework to be able to create >workbooks from various data sources. Some of the people I have worked who use >Excel heavily often times have to go through several steps to extract data >from >databases and CSV files before then can build their workbooks. Usually it is >aggregating data from many sources into a single workbook. This can be a time >consuming task simply due to the number files or databases with which they >have >to interact. A lot of these aren't problems I personally face, but I suspect quite a lot of users (and potential users!) do, so if you're happy to work on it then I don't see why we shouldn't have it! In terms of the CSV and SQL bits, it's possible that we'd be better off looking at somethingl like Apache Cocooon to do the transformations for these. It's quite likely that we'd need to do a few tweaks to the POI Excel output types (not sure how much love they've had lately), but that could deliver a wide range of inputs very easily. The excel ant step could then just be configuring up a cocoon pipeline based on the options given in ant, rather than having to do loads of other coding too! Nick --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
