[jbossseam-issues] [JBoss JIRA] Updated: (JBSEAM-2896) component set for generating excel documents

[Daniel Roth (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBSEAM-2896?page=all ]

Daniel Roth updated JBSEAM-2896:
--------------------------------

    Attachment: excel_svn_150.zip

I have attached the source including excel support, docs, example webapp and one build pom (defining where to get the correct jxl version). I could probably diff, but all files are new so you could just add them,

Some effort is needed to put the source to work in seam's build. The overall structure should however follow the seam trunk (unless it again has been modified....;-).

The code probably needs some tuning, but the functionality "is there", to the extent that it correctly delivers nice xls documents.

Some cut n' paste from an earlier mail to Pete (slightly modified):

* Document store stuff has been totally ripped from the pdf code. I have just renamed the components from pdf->excel. The main reason is that the seam dev-list had quite a few suggestions on how to integrate document store with pdf and use CDK etc, but since I haven't even got jboss/seam svn commit access, I thought it seemed a bit akward to come up with that kind of build/infrastructural stuff. Copying the pdf sample will make it easy to integrate them both in any upcoming "seam core document store".

* The module supports "any" kind of excel(or whatever else) export you might like, by getting an instance of "YYY.XXX" where XXX is defined in the "type" attribute of UIWorkbook and YYY is defined by the namespace attribute of the Excel Factory. That instance must implement the ExcelWorkbook interface. Not setting it, will use "org.jboss.seam.excel.jxl" as default, which exports a nice excel file. There is a small csv exporter bundled too, but it was a 10 minute job... This way an end developer could use his own exporter for POI, xml, that-format-openoffice-uses with ease.

> component set for generating excel documents
> --------------------------------------------
>
>                 Key: JBSEAM-2896
>                 URL: http://jira.jboss.com/jira/browse/JBSEAM-2896
>             Project: Seam
>          Issue Type: Feature Request
>          Components: JSF Controls
>    Affects Versions: 2.0.2.CR1, 2.1.0.A1, 2.0.1.GA
>            Reporter: Dan Allen
>             Fix For: The future
>
>         Attachments: excel_svn_150.zip
>
>   Original Estimate: 1 week
>  Remaining Estimate: 1 week
>
> We should mirror the functionality of creating PDF documents from Facelets templates and create a component set that generates excel documents. There are two approaches we can take. One approach is to use POI to build the document structure and then export it. The second approach is to build an XML document that Excel can understand. Technically there is no reason to actually produce a binary Excel document as long as we can feed something that Excel knows how to convert. Regular CSV support would be nice too, but I always find that to be such a cop out.
> Creating this module shouldn't be too technically challenging since most of the infrastructure has been set up already when creating the PDF components. In fact, i would start by working in that module and then split it out into another JAR.
> Some resource links:
> http://www.codeproject.com/KB/office/excelxmllibrary.aspx
> http://xelem.sourceforge.net/

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira