turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Crossen" <ccros...@home.com>
Subject Re: MS Excel and setContentType
Date Mon, 15 Oct 2001 08:41:46 GMT
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" <sbailliez@imediation.com>
To: <turbine-user@jakarta.apache.org>
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:ccrossen@home.com]
> Sent: Monday, October 15, 2001 10:16 AM
> To: turbine-user@jakarta.apache.org
> 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" <sbailliez@imediation.com>
> To: <turbine-user@jakarta.apache.org>
> 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:ccrossen@home.com]
> > Sent: Thursday, October 11, 2001 12:02 AM
> > To: turbine-user@jakarta.apache.org
> > 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" <fedor.karpelevitch@Barra.COM>
> > To: <turbine-user@jakarta.apache.org>
> > 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:Wei.Ru@botcc.com]
> > > > Sent: Wednesday, October 10, 2001 1:05 PM
> > > > To: turbine-user@jakarta.apache.org
> > > > 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:
> > turbine-user-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail:
> > turbine-user-help@jakarta.apache.org
> > > >
> > >
> >
>
> --------------------------------------------------------------------
> > -
> > > To unsubscribe, e-mail:
> turbine-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> > turbine-user-help@jakarta.apache.org
> > >
> >
> >
>
> --------------------------------------------------------------------
> -
> > To unsubscribe, e-mail:
turbine-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> turbine-user-help@jakarta.apache.org
> >
>
> --------------------------------------------------------------------
-
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
turbine-user-help@jakarta.apache.org
>
>
>
>
> --------------------------------------------------------------------
-
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
turbine-user-help@jakarta.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org


Mime
View raw message