Yes I understand that this is working if you send back html...however if we want to send back a .csv I'm curious to know what would be the workaround.
-- St�phane Bailliez Software Engineer, Paris - France iMediation - http://www.imediation.com Disclaimer: All the opinions expressed above are mine and not those from my company. > -----Original Message----- > From: Chris Crossen [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 15, 2001 10:16 AM > To: [EMAIL PROTECTED] > Subject: Re: MS Excel and setContentType > > > Excel recognizes html. An html table passed to Excel will be rendered > as a spreadsheet. > > Have you tried the sample from my previous message? I put it into my > template directory, invoked it from IE, and Excel opened with the > spreadsheet you would expect to see. > > ----- Original Message ----- > From: "Stephane Bailliez" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, October 15, 2001 1:11 AM > Subject: RE: MS Excel and setContentType > > > > May I ask how you manage to disable the page assembler to stuff a > different > content type in the response ? > > I don't see how you can send back something else correct since the > page > assembler will add html tags around your data...unless I missed > something I > don't see how we can do this without creating our own VelocityPage > that > implements a different strategy for assembling a page. > > -- > St�phane Bailliez > Software Engineer, Paris - France > iMediation - http://www.imediation.com > Disclaimer: All the opinions expressed above are mine and not those > from my > company. > > > > > -----Original Message----- > > From: Chris Crossen [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, October 11, 2001 12:02 AM > > To: [EMAIL PROTECTED] > > Subject: Re: MS Excel and setContentType > > > > > > If you have Excel on the client (and probably if you are running the > > IE browser on the client), you can cause Excel to open from a page. > > You are on the right track with setting the content type. Put this > in > > a template and try it. > > > > $data.setContentType( "application/vnd.ms-excel" ) > > <table> > > <tr> > > <td>text1</td> > > <td>1</td> > > </tr> > > <tr> > > <td>text2</td> > > <td>2</td> > > </tr> > > </table> > > > > It is even possible to put special strings in the TD tags to use > Excel > > formatting and Excel formulas in the resulting spreadsheet. Let me > > know if you want more information. > > > > Chris > > > > ----- Original Message ----- > > From: "Fedor Karpelevitch" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, October 10, 2001 2:00 PM > > Subject: RE: MS Excel and setContentType > > > > > > > Cross your fingers. > > > > > > seriously. if you set cont type to something which the file is not > > (like in > > > your case html is not an xml spreadsheet whatever you are trying > to > > claim). > > > If you want to have a certain type of file to be open with certain > > app you > > > have to configure the client machine to associate this type with > > that app. > > > Or use an existing association (s.a. the csv hack proposed) > > > > > > fedor. > > > > > > ------------------------------- > > > Amicus Plato amicus Aristoteles magis amica veritas > > > > > > > -----Original Message----- > > > > From: Wei Ru [mailto:[EMAIL PROTECTED]] > > > > Sent: Wednesday, October 10, 2001 1:05 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: MS Excel and setContentType > > > > > > > > > > > > Hi, > > > > > > > > I am trying to generate a report using html and open it on the > > browser > > > > by MS Excel. I am trying to use > > > > data.setContentType("application/vnd.ms-excel"); then feed the > > content > > > > some dynamicly generated html text > > > > Can any one suggest me a best way to do that? > > > > > > > > Thanks > > > > > > > > Wei Ru > > > > > > > > > > > -------------------------------------------------------------------- > > - > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > -------------------------------------------------------------------- > > - > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > -------------------------------------------------------------------- > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
