[
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