>- see footer for list info -< <cfcontent type="application/vnd.ms-excel" file="c:\excel\yourexcel.xls" deletefile="Yes"> displayes it in browser
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Swingewood Sent: Thursday, January 27, 2005 12:24 PM To: [email protected] Subject: [work] [CF-Dev] Output to excel >- 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 -< --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 0504-2, 01/27/2005 Tested on: 1/27/2005 1:06:55 PM avast! - copyright (c) 1988-2004 ALWIL Software. http://www.avast.com _______________________________________________ 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 -<
