R: XML to Excel file

2002-10-29 Thread Lorenzo De Sio
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

2002-10-29 Thread Antonio Gallardo Rivera
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

2002-10-28 Thread Dorsey, Chris
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

2002-10-28 Thread Markdelanoy
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

2002-10-28 Thread Boris Althaus



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

2002-10-28 Thread Ryan Agler
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

2002-10-28 Thread Mark Eggers
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

2002-10-28 Thread Hugo Burm
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]