That would certainly be a possible work-around Thanks a lot
Michael Litrik De Roy wrote: >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]> > --------------------------------------------------------------------- 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]>
