>- see footer for list info -< Excel will except plain old HTML formatted tables, just set the header to say it's an excel file and it should open in excel. Any of the cf_excel tags should show u a good example.
Russ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Robertson-Ravo, Neil (RX) > Sent: 20 April 2005 16:10 > To: Coldfusion Development > Subject: RE: [CF-Dev] Download a returned recordset > > >- see footer for list info -< > What if the data contains commas already...I know you can > escape them etc..but seems like such a pain in the arse...POI > ....fast and effective.. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tomo > Sent: 20 April 2005 16:09 > To: Coldfusion Development > Subject: Re: [CF-Dev] Download a returned recordset > > >- see footer for list info -< > what's wrong with a CSV? > > Robertson-Ravo, Neil (RX) wrote: > >>- see footer for list info -< > > > > Depending on what it is you can get strange results when > outputting to > > Excel. We use POI for Query to Excel and Excel to Query but > we are on > > MX - you may be able to use it on CF5 though just a little more > > convoluted I would think. > > > > http://jakarta.apache.org/poi/index.html > > > > This is very fast, very reliable. > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > Simon Baynes > > Sent: 20 April 2005 15:50 > > To: Coldfusion Development > > Subject: Re: [CF-Dev] Download a returned recordset > > > > > >>- see footer for list info -< > > > > Why are you using a structure? Just output the results form > the query > > to the page. > > > > Does your query change much? If not the cache it and that will save > > database hits. > > > > On 4/20/05, Stephen Adams <[EMAIL PROTECTED]> wrote: > > > >>>- see footer for list info -< > >> > >>Hi, > >> > >>I have a query which displays a large number of result, anywhere > >>between > > > > 500 > > > >>to 1800. Now not only do I want to display the results in > my page. I > >>want > > > > to > > > >>allow the user to download this result set into an Excel file. > >> > >>The idea I am thinking of using is placing the results into a > >>structure > > > > and > > > >>then using this structure to loop through in one page to > display the > >>results, and then when the user decides they wish to download this > >>result set, loop through the structure again in another > file creating > >>the > > > > download > > > >>excel file, using cfhttp and cfcontent. > >> > >>But I am worried about the performance of this, will this > method be to > > > > slow, > > > >>is there another way I could do this. Unfortunately the site is > >>running on CF5, no CF7, bugger! > >> > >>Stephen > >>_______________________________________________ > >> > >>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 -< > > > > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed > > Business, Registered in England, Number 678540. It contains > > information which is confidential and may also be > privileged. It is > > for the exclusive use of > the > > intended recipient(s). If you are not the intended recipient(s) > > please > note > > that any form of distribution, copying or use of this > communication or > > the information in it is strictly prohibited and may be > unlawful. If > > you have received this communication in error please return > it to the > > sender or > call > > our switchboard on +44 (0) 20 89107910. The opinions > expressed within > this > > communication are not necessarily those expressed by Reed > Exhibitions. > > Visit our website at http://www.reedexpo.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 -< > > > > > > > _______________________________________________ > > 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 e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a > division of Reed Business, Registered in England, Number > 678540. It contains information which is confidential and > may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note that any form of distribution, > copying or use of this communication or the information in it > is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call our switchboard on +44 (0) 20 89107910. The > opinions expressed within this communication are not > necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.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 > >-< > _______________________________________________ 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 -<
