[cfaussie] Re: Outputting to Excel - how to incorporate styles

Wed, 13 Sep 2006 21:04:34 -0700

Actually Dale is correct. The standard way to generate excel spreadsheets the way you want is to generate an html table and set the doc type to application/vnd.ms-excel the way you have. When a user opens the page, their browser detects the mime type and opens the page in excel and excel 'magically' creates the spreadsheet. I can't speak for the style stuff though as I've never had that kind of requirement.

Blair

On 9/14/06, Mike Kear <[EMAIL PROTECTED]> wrote:

Thanks again Dale.   I dont want to out put a HTML page, i want to
output a XLS worksheet- an excel spreadsheet, not a HTML
representation of an excel spreadsheet.

If i do a html page, it displays on the browser screen.  It doesnt
download.  After all, the whole purpose of this functionality is to
allow users to download as a spreadsheet  the data they're already
seeing in the browser

I sincerely appreciate your interest, Dale, but I dont think I've
explained the task adequately enough perhaps.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

On 9/14/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> And my third post about embedding the style was correct.
>
> <cfcontent type="application/vnd.ms-excel">
> <html>
>         <head>
>                 <style>
>                         .forMike { color:red; background:#00FF99; }
>                 </style>
>         </head>
>
>         <body>
>                 <table>
>                         <tr>
>                                 <td class="forMike">Just Guessing!</td>
>                         </tr>
>                 </table>
>         </body>
> </html>
>
> I'm not sure what you tried, but it doesn't get much simpler than this.
>
> Regards
> Dale Fraser
>
> http://dale.fraser.id.au
>
>
>
>
>
> -----Original Message-----
> From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf
> Of Mike Kear
> Sent: Thursday, 14 September 2006 13:27 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Outputting to Excel - how to incorporate styles
>
>
> Dale are you suggesting this based on what you have ACTUALLY done or
> what you think ought to be the case?
>
> Because as I said in my original posting, there are quire a few things
> I've tried without success.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On 9/14/06, Dale Fraser < [EMAIL PROTECTED]> wrote:
> >
> > Just embed the style tag
> >
> > <style>
> >         .myStyle color: #FFFF00;
> > </style>
> >
> >
> > Regards
> > Dale Fraser
> >
> > http://dale.fraser.id.au
> >
>
>
>
>
> >
>


--


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to