FYI,
This is how I integrate some Excel spreadsheets in a (fairly static) web
site. The data (tennis results) is sent to me as an Excel spreadsheet. (This
is is far from perfect but at least it is better than a table in an MS Word
document. :-)
1) The old way (Before Cocoon, data in Excel 97)
Before Cocoon, I had all documents for the site as xml documents sitting on
my harddisk. Using Xalan, I applied a stylesheet to convert everything into
HTML. I saved the spreadsheet (made in Excel 97) to HTML and simply
copy/pasted everything in the HTML documents that needed the information.
The result was an HTML table that did not really look like the Excel
spreadsheet but at least all the data was there and it did not have fixed
sizes for cells, so everything resized nicely according to the browser
window.
2) The new way (Using Cocoon, data in Excel 2000)
I still get data in Excel, but now in Excel 2000 instead of Excel 97. The
problem is that the 'Save as HTML' of Excel 2000 is way too smart. It saves
every bit of information about the layout of the sheet so it can be
recreated when opened again in Excel. But it is a lot harder to get 'just'
the data. My solution for this is to 'cinclude' the HTML version of the
spreadsheet AFTER applying a stylesheet that removes some HTML/CSS
information that defines the fixed size.
The following XSLT snippet is all that is required to remove some of the
unwanted HTML/CSS:
<xsl:template match="/">
<xsl:copy-of select="//style"/>
<table style="border-collapse: collapse;width:100%;" cellspacing="0"
cellpadding="0" border="0" str="x:str">
<xsl:copy-of select="//table/child::*"/>
</table>
</xsl:template>
The result is an HTML table that does resize nicely but still looks like the
original Excel 2000 version. A static version is available at
http://users.skynet.be/litrik/rolmite/en/gv_palmares.html
PS: I did look at the POI project but figured out it would be overkill for
the stuff I am trying to do.
Just sharing my experience...
Litrik De Roy
www.litrik.com
----- Original Message -----
From: "Sven Kuenzler" <[EMAIL PROTECTED]>
Newsgroups: gmane.text.xml.cocoon.user
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 2:57 PM
Subject: Re: Excel generator
> > Is there an Excel Generator, which creates *from* an Excel (xls) file
> > some XML? Or what approach would you take to convert existing Excel
> > documents into some useful XML?
>
> I think the previous responses missed the *from* (my emphasis) :-)
> So, read Andy's answer on the dev list. In short: No, there is no
> HSSFGenerator (yet).
>
> Sven
>
>
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
