- see footer for list info -<
Yep! - Thats the one. Thanks as always Duncan (and to all that helped)
Regards - Paul
From: "Duncan Cumming" <[EMAIL PROTECTED]> Reply-To: Coldfusion Development <[email protected]> To: <[email protected]> Subject: Re: [CF-Dev] Output to excel Date: Thu, 27 Jan 2005 13:34:47 +0000
>- see footer for list info -< <cfsavecontent variable="excelData"> <table> <!--- HEADER ---> <cfoutput> <tr> <td>Cell A1</td><td>Cell A2</td> </tr>
<tr> <td>Cell b1</td> <td>Cell b2</td> <td>cell b3</td> <td>cell b4</td> </tr> </cfoutput> </table> </cfsavecontent>
<cfoutput>#excelData#</cfoutput>
<cffile action="WRITE" file="c:\wherever\whatever.xls" output="#excelData#">
<a href="whatever.xls">Download the above data</a>
Duncan Cumming New Media Developer Customer Relations Management / Education Fife Council 700 4105 / 01592 414105
>>> [EMAIL PROTECTED] 27/01/2005 12:23:51 >>> >- see footer for list info -< I need to output some data to an excel spreadsheet. I want the user to be able to see the sheet on the screen and either print it or save it as an excel file.
I have this (from livedocs)
<!--- use cfsetting to block output of HTML outside of cfoutput tags ---> <cfsetting enablecfoutputonly="Yes"> <cfcontent type="application/msexcel"> <cfheader name="Content-Disposition" value="filename=Test.xls"> ---> <cfoutput><table></cfoutput> <!--- HEADER ---> <cfoutput> <tr> <td>Cell A1</td><td>Cell A2</td> </tr>
<tr> <td>Cell b1</td> <td>Cell b2</td> <td>cell b3</td> <td>cell b4</td> </tr> </cfoutput> <cfoutput></table></cfoutput>
This only shows the data on the screen in HTML. How do I make this appear as an excel spread sheet? (the CFsetting as yes or no doesn't seem to make any difference)
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
-- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
**********************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and should not be disclosed to any other party.
If you have received this email in error please notify your system manager and the sender of this message.
This email message has been swept for the presence of computer viruses but no guarantee is given that this e-mail message and any attachments are free from viruses.
Fife Council Tel: +44 (0) 1592 414141 **********************************************************************
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo
-- CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -< - Forum provided by www.fusetalk.com -< - DHTML Menus provided by www.APYCOM.com -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
