- 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 -<
