cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antonio Gallardo Rivera <agalla...@agsoftware.dnsalias.com>
Subject Re: R: XML to Excel file
Date Tue, 29 Oct 2002 19:45:09 GMT
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: cocoon-users@xml.apache.org
> 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 cocoon-users@xml.apache.org
>
> Boris
>
>
> ----- Original Message -----
> From: Dorsey, Chris
> To: cocoon-users@xml.apache.org
> 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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
>
> ---------------------------------------------------------------------
> 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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>

---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message