Ah ! thanks for putting me on the way, I discovered RawScreen which might be a good start point for such thing.
-- 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:42 AM > To: [EMAIL PROTECTED] > Subject: Re: MS Excel and setContentType > > > The declareDirectResponse method of RunData is probably what you are > after. > > I've never used .csv files to invoke Excel from a browser, that was > suggested by someone else. You won't get the Excel Formatting and > Formula capabilities using .csv. > > If you have existing .csv files you want to use, you could always > format them into an html table with a velocity template. > > Chris > > ----- Original Message ----- > From: "Stephane Bailliez" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, October 15, 2001 1:31 AM > Subject: RE: MS Excel and setContentType > > > > 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] > > > > --------------------------------------------------------------------- > 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]
