>- see footer for list info -< this is what i use to export <cfsetting enablecfoutputonly="yes" showdebugoutput="no" /> <cfheader name="cache-control" value="0"> <cfheader name="content-disposition" value="inline; filename=""something.xls"""> <cfcontent type="application/msexcel"> <cfoutput>First name#chr(9)#Last name#chr(9)#Email address#chr(13)#</cfoutput> <cfoutput query="recipientsList">#first_name##chr(9)##last_name##chr(9)##email_address##chr(13)#</cfoutput>
i instead use chr codes for tabs and spaces, have never tried it the html way. > >- 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 -< _______________________________________________ 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 -<
