[jbossseam-issues] [JBoss JIRA] Commented: (JBSEAM-2896) component set for generating excel documents
[ http://jira.jboss.com/jira/browse/JBSEAM-2896?page=comments#action_12410258 ]
Daniel Roth commented on JBSEAM-2896:
-------------------------------------
There have been some work done on this jira. Nicklas Karlsson and I have, at the moment, a
prototype working which works similar as the itext pdf generator. There are quite some
work to do but this is a small example on what works right now. We use Jexcel as engine
(LGPL).
<e:workbook xmlns="http://www.w3.org/1999/xhtml"
xmlns:e="http://jboss.com/products/seam/excel"
xmlns:f="http://java.sun.com/jsf/core" >
<e:worksheet name="Data" value="#{excelstuff.people}"
var="person">
<e:column>
<f:facet name="header">
<e:cell value="Name" />
</f:facet>
<e:cell value="#{person.name}" type="text"/>
</e:column>
<e:column>
<f:facet name="header">
<e:cell value="Lastname" />
</f:facet>
<e:cell value="#{person.lastName}" type="text"/>
</e:column>
</e:worksheet>
</e:workbook>
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: 2.1.x
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