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

Daniel Roth (JIRA) jira-events at lists.jboss.org
Wed Apr 23 11:02:45 EDT 2008


    [ 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

        



More information about the seam-issues mailing list