Boris, I think your message got a bit underlooked: I agree it is quite a dirty trick, but it actually seems to work.
I tried on both Excel 97 and 2000: in both cases the file gets correctly opened, and it retains the original HTML formatting (multiple colspan, colors, etc.). As you save the file from within Excel, it seems to get saved in XLS binary format, which prevents further HTML conversions as the file is opened later. Since I think that most time spent on M$ proprietary formats could be better spent :-), I definitely suggest anyone needing such a solution to give it a try. I actually added such a line to the sitemap: <map:serializer name="xls" mime-type="application/vnd.ms-excel" src="org.apache.cocoon.serialization.HTMLSerializer" > I think that the POI HSSF approach is definitely the right way to go, but I also think that it can be quite time-consuming (the need to write an alternate XSL in yet-another markup language can be quite tedious, especially for complex tables, since the GNumeric format also requires you to think in quite a different way from HTML table logic). I would appreciate any comments, L. -----Messaggio originale----- Da: Boris Althaus [mailto:boris@;petra-productions.de] Inviato: luned́ 28 ottobre 2002 17.43 A: [EMAIL PROTECTED] Oggetto: Re: XML to Excel file Hi Chris, when you set the content-type in a servlet like "response.setContentType("application/vnd.ms-excel");" a simple html-table will opened as excel-file, if Excel is installed. but i think it is not a question for [EMAIL PROTECTED] Boris ----- Original Message ----- From: Dorsey, Chris To: [EMAIL PROTECTED] Sent: Monday, October 28, 2002 5:25 PM Subject: XML to Excel file Does anyone have recommendations on how to get from an XML stream to an Excel file without using cocoon? --------------------------------------------------------------------- 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]>