+1 to POI. jXLS is also nice if you need templating. But +2 to SSIS (or similar). CF as a data pump just does not scale.
Jaime > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 19 August 2008 1:56 AM > To: CF-Talk > Subject: RE: Best method for Export to Excel... > > With 20,000 records, do you actually need to create it > on-demand for each user? > > Can you have a scheduled task rebuild the .xls file every so often? > > If that would work, then you could just have SSIS dump the > .xls file on your web server. > > This would take CF completely out of the process. > > m!ke > > -----Original Message----- > From: jonese [mailto:[EMAIL PROTECTED] > Sent: Monday, August 18, 2008 10:09 AM > To: CF-Talk > Subject: Best method for Export to Excel... > > Hey all, > > I've got lots of ideas. done this a million times. but wanted > to just check in with the crowd to see if maybe I've missed > something new etc. > > I've got about 20k records in a sql 2005 DB table which i > need to dump to an excel file on demand for users. > > Basically inside a cfthread tag I'm grabbing the 20k records > from a web service, dumping them into a table, and then need > to go from that table to an excel file and email / provide a > download link for the end user. > > Best practices? super duper suggestions? > > thanks in advance! > > jonese > http://www.jonese.us > http://twitter.com/jonese > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4