R: XML to Excel file
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]
Re: R: XML to Excel file
El Martes, 29 de Octubre de 2002 04:50, Lorenzo De Sio escribió: 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). It depends, you can write a general XSL and then try to sort the data as they can be interpreted by the general XSL. The true about XSL is that you write it once and use it many times. This is the reason I love Cocoon and XSL. Antonio Gallardo 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] - 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]
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]
Re: XML to Excel file
Look at the POI project on jakarta.apache.org specifically HSSF. You'd need to parse the XML yourself but POI allows you to read/write Excel files. MD - 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]
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 anExcel file without using cocoon?-Please check that your question has not already been answered in theFAQ before posting. http://xml.apache.org/cocoon/faq/index.htmlTo unsubscribe, e-mail: [EMAIL PROTECTED]For additional commands, e-mail: [EMAIL PROTECTED]
RE: XML to Excel file
Not a full-blown solution, but you can encode a web page with tags in the Excel namespace xmlns:x=urn:schemas-microsoft-com:office:excel and, use formulas etc in html table cells: td style=width:0pt x:fmla==COUNT(A4:A9) width=0 class=x868 span style=mso-spacerun: yes/ /td Try saving an .xls file to .html, and you will get the jist of the format. Then, you can transform your XML data to an Excel-marked-up .html page using XSLT. Just a thought. -Original Message- From: [EMAIL PROTECTED] [mailto:Markdelanoy;aol.com] Sent: Monday, October 28, 2002 11:31 AM To: [EMAIL PROTECTED] Subject: Re: XML to Excel file Look at the POI project on jakarta.apache.org specifically HSSF. You'd need to parse the XML yourself but POI allows you to read/write Excel files. MD - 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]
Re: XML to Excel file
Take a look at POI at http://jakarta.apache.org/poi/index.html to see if it meets your needs. /mde/ just my two cents . . . . __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - 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]
RE: XML to Excel file
Try Perl. I have some good experiences with CPAN modules that parse XML streams and write to Excel. You ony need a few lines of Perl code, it is fast, but it does exactly that (and only that) what you are asking for: convert an XML stream into an Excel file. Cocoon is a different kind of animal. Hugo -Original Message- From: Dorsey, Chris [mailto:chris.dorsey;bankofamerica.com] Sent: Monday, October 28, 2002 5:25 PM To: [EMAIL PROTECTED] 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]