>- see footer for list info -< Pardon my ignorance but what is POI? On 4/20/05, Tomo <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > or you could go the vile route of generating HTML tables and renaming > the file xls... > > how long does poi take to install and configure? > > > Robertson-Ravo, Neil (RX) wrote: > >>- 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 -< > _______________________________________________
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 -<
