Re: Excel serializer for Cocoon !
- Original Message - From: Yann SECQ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:32 AM Subject: POI : Excel serializer for Cocoon ! Hi Cocoonners, it's not yet ready for prime time, but here is a great projet for Cocoon users : an Excel serializer. Could we hope an integration within Cocoon2 for Christmas ;) Hi Yann!! it would be fine to get it work with Cocoon2 I very need such stuff for working with my reports and serializing it to Excel How can i (we) help in developing/testing POI? and has it alpha version of serializer already working? Best regards , Igor Sazhnev - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
using style tags This is a well-known feature with best wishes Alexander Kachanov -Original Message- From: Yann SECQ [mailto:[EMAIL PROTECTED]] Sent: 29 ~q 2001 s. 18:52 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Alex Kachanov wrote: Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? Alex, I'm curious to see how you embed formulas within HTML table ! Cheers, yann. -- / Yann SECQEquipe SMAC [EMAIL PROTECTED] \ | Multi-Agent Systems Modeling Agent Oriented Programming | \ http://www.lifl.fr/SMAChttp://www.lifl.fr/~secq / - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Excel serializer for Cocoon !
Igor Sazhnev wrote: Hi Yann!! it would be fine to get it work with Cocoon2 I very need such stuff for working with my reports and serializing it to Excel How can i (we) help in developing/testing POI? and has it alpha version of serializer already working? Best regards , Igor Sazhnev Hi Igor, I'm not involved in this project, but I'm sure they are looking for people wishing to help. Go to to their home page : http://sourceforge.net/projects/poi and contact the administrators of POI : http://sourceforge.net/users/marcj/ http://sourceforge.net/users/acoliver2/ Cheers, yann. -- / Yann SECQEquipe SMAC [EMAIL PROTECTED] \ | Multi-Agent Systems Modeling Agent Oriented Programming | \ http://www.lifl.fr/SMAChttp://www.lifl.fr/~secq / - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
to be more specific http://www.microsoft.com/exceldev/articles/ch11.htm any feature: formulas, formating, filters, pivot tables whatever you want - without those COMs and ActiveXs with best wishes Alexander Kachanov -Original Message- From: Alex Kachanov Sent: 29 ~q 2001 s. 18:55 To: [EMAIL PROTECTED] Subject: RE: Excel serializer for Cocoon ! using style tags This is a well-known feature with best wishes Alexander Kachanov -Original Message- From: Yann SECQ [mailto:[EMAIL PROTECTED]] Sent: 29 ~q 2001 s. 18:52 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Alex Kachanov wrote: Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? Alex, I'm curious to see how you embed formulas within HTML table ! Cheers, yann. -- / Yann SECQEquipe SMAC [EMAIL PROTECTED] \ | Multi-Agent Systems Modeling Agent Oriented Programming | \ http://www.lifl.fr/SMAChttp://www.lifl.fr/~secq / - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Excel serializer for Cocoon !
Does Excel mime-type work with Netscape and other browsers than IE ? - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
yes IE opens Excel without any prompt inside itself while netscape just throws a dialog box What you wanna do with this file If you hit open - Netscape starts Excel and Excel opens you html file with best wishes Alexander Kachanov -Original Message- From: Tomas Espeleta [mailto:[EMAIL PROTECTED]] Sent: 29 ~q 2001 s. 19:00 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Does Excel mime-type work with Netscape and other browsers than IE ? - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Excel serializer for Cocoon !
Alex Kachanov wrote: Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? Alex, I'm curious to see how you embed formulas within HTML table ! ...and I think that mime-type works only with IE - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
It's not Already tested on Netscape, Opera, IE C'mon guys I've developed a whole registration application using this feature. with best wishes Alexander Kachanov -Original Message- From: Tomas Espeleta [mailto:[EMAIL PROTECTED]] Sent: 29 ?? 2001 ?. 18:54 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Alex Kachanov wrote: Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? Alex, I'm curious to see how you embed formulas within HTML table ! ...and I think that mime-type works only with IE - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Excel serializer for Cocoon !
C'mon guys I've developed a whole registration application using this feature. Ok, sorry, it was only a doubt.. ;-) - Tomas. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
try youself if application/vnd.ms-excel MIME type is registered in you system ANY browser will understand this. The behaviour will be different, but the result will be the same: you will see your page in Excel. (Actually, it's interesting usage of Excel as a browser) with best wishes Alexander Kachanov -Original Message- From: Alex Kachanov Sent: 29 ?? 2001 ?. 19:12 To: [EMAIL PROTECTED] Subject: RE: Excel serializer for Cocoon ! It's not Already tested on Netscape, Opera, IE C'mon guys I've developed a whole registration application using this feature. with best wishes Alexander Kachanov -Original Message- From: Tomas Espeleta [mailto:[EMAIL PROTECTED]] Sent: 29 ?? 2001 ?. 18:54 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Alex Kachanov wrote: Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? Alex, I'm curious to see how you embed formulas within HTML table ! ...and I think that mime-type works only with IE - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Excel serializer for Cocoon !
- Original Message - From: "Alex Kachanov" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:54 AM Subject: RE: Excel serializer for Cocoon ! Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? one another example : in my report one column is a number like 23.1 or 45.6 when i simple write in xsl tdxsl:value-of select="tralala"//td in what case Excel show me not 23.1 but 23.januar - ie it parse it as day and month and properly display 45.6 - because there is no momth with 45 days in it :)) in that case i must use vnd.ms-excel.numberformat:#.#; style in table cell to excel display it properly But it must done not by me - its work of serializer And again - i need to pass original document formatting to excel (ie cell , border, color etc) - but then i tried to change mime-type it works only in msexcell200 but in excel97 - not And its not all :)) - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
But it must done not by me - its work of serializer It's a work of your stylesheet. with best wishes Alexander Kachanov -Original Message- From: Igor Sazhnev [mailto:[EMAIL PROTECTED]] Sent: 29 $B'_'`'q'R'b'q(J 2001 $B'T(J. 19:20 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! - Original Message - From: "Alex Kachanov" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:54 AM Subject: RE: Excel serializer for Cocoon ! Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? one another example : in my report one column is a number like 23.1 or 45.6 when i simple write in xsl tdxsl:value-of select="tralala"//td in what case Excel show me not 23.1 but 23.januar - ie it parse it as day and month and properly display 45.6 - because there is no momth with 45 days in it :)) in that case i must use vnd.ms-excel.numberformat:#.#; style in table cell to excel display it properly But it must done not by me - its work of serializer And again - i need to pass original document formatting to excel (ie cell , border, color etc) - but then i tried to change mime-type it works only in msexcell200 but in excel97 - not And its not all :)) - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
But it must done not by me - its work of serializer It's a work of your stylesheet. Just define the data type as attribute in your xml file and then parse this attribute in your stylesheet as they do in those classic examples like price currency="USD" type="currency"30/price with best wishes Alexander Kachanov -Original Message- From: Igor Sazhnev [mailto:[EMAIL PROTECTED]] Sent: 29 $B'_'`'q'R'b'q(J 2001 $B'T(J. 19:20 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! - Original Message - From: "Alex Kachanov" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:54 AM Subject: RE: Excel serializer for Cocoon ! Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? one another example : in my report one column is a number like 23.1 or 45.6 when i simple write in xsl tdxsl:value-of select="tralala"//td in what case Excel show me not 23.1 but 23.januar - ie it parse it as day and month and properly display 45.6 - because there is no momth with 45 days in it :)) in that case i must use vnd.ms-excel.numberformat:#.#; style in table cell to excel display it properly But it must done not by me - its work of serializer And again - i need to pass original document formatting to excel (ie cell , border, color etc) - but then i tried to change mime-type it works only in msexcell200 but in excel97 - not And its not all :)) - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Excel serializer for Cocoon !
- Original Message - From: Yann SECQ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:52 AM Subject: Re: Excel serializer for Cocoon ! Alex Kachanov wrote: Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? Alex, I'm curious to see how you embed formulas within HTML table ! Cheers, yann. as i know it done throw td=sum(a1:c1)/td or tdFORMULA=sum(a1:c1)/td its information from one of msdn articles :) Ratty - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
Ah, but what happens when you have a unix system without an excel executable? Alex -Original Message- From: Alex Kachanov [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 5:06 AM To: [EMAIL PROTECTED] Subject: RE: Excel serializer for Cocoon ! yes IE opens Excel without any prompt inside itself while netscape just throws a dialog box What you wanna do with this file If you hit open - Netscape starts Excel and Excel opens you html file with best wishes Alexander Kachanov -Original Message- From: Tomas Espeleta [mailto:[EMAIL PROTECTED]] Sent: 29 ~q 2001 s. 19:00 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Does Excel mime-type work with Netscape and other browsers than IE ? - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
map:serializer name=html2xsl mime-type=application/vnd.ms-excel src=org.apache.cocoon.serialization.HTMLSerializer with best wishes Alexander Kachanov -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 ~q 2001 s. 23:51 To: [EMAIL PROTECTED] Subject: RE: Excel serializer for Cocoon ! Thanks for the knowledge, Could you give me some detail as to what needs to go into the sitemap.xmap. map:serializer name=xls src=?? mime-type= application/vnd.ms-excel/ what would go into the src attribute? thanks, j Alex Kachanov [EMAIL PROTECTED] on 11/29/2001 05:14:47 AM Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: RE: Excel serializer for Cocoon ! try youself if application/vnd.ms-excel MIME type is registered in you system ANY browser will understand this. The behaviour will be different, but the result will be the same: you will see your page in Excel. (Actually, it's interesting usage of Excel as a browser) with best wishes Alexander Kachanov -Original Message- From: Alex Kachanov Sent: 29 ?? 2001 ?. 19:12 To: [EMAIL PROTECTED] Subject: RE: Excel serializer for Cocoon ! It's not Already tested on Netscape, Opera, IE C'mon guys I've developed a whole registration application using this feature. with best wishes Alexander Kachanov -Original Message- From: Tomas Espeleta [mailto:[EMAIL PROTECTED]] Sent: 29 ?? 2001 ?. 18:54 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Alex Kachanov wrote: Why do we need Excel serizalier at all, when you can just change content type to excel mime type and any browser will launch excel automatically and reformat your HTML table as you wish? Alex, I'm curious to see how you embed formulas within HTML table ! ...and I think that mime-type works only with IE - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.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/faqs.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/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Excel serializer for Cocoon !
Why then you need Excel file in your browser and Excel serizalizer at all? with best wishes Alexander Kachanov -Original Message- From: Alex Vishnev [mailto:[EMAIL PROTECTED]] Sent: 30 ~q 2001 s. 10:31 To: [EMAIL PROTECTED] Subject: RE: Excel serializer for Cocoon ! Ah, but what happens when you have a unix system without an excel executable? Alex -Original Message- From: Alex Kachanov [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 5:06 AM To: [EMAIL PROTECTED] Subject: RE: Excel serializer for Cocoon ! yes IE opens Excel without any prompt inside itself while netscape just throws a dialog box What you wanna do with this file If you hit open - Netscape starts Excel and Excel opens you html file with best wishes Alexander Kachanov -Original Message- From: Tomas Espeleta [mailto:[EMAIL PROTECTED]] Sent: 29 ~q 2001 s. 19:00 To: [EMAIL PROTECTED] Subject: Re: Excel serializer for Cocoon ! Does Excel mime-type work with Netscape and other browsers than IE ? - Tomas - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.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/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
