Mike, I highly recommend cfx_ss http://www.sanders-indev.com/cfxssdoc.htm
It is very fast although doesn't convert to excel format only csv. Jared Clinton NEC Australia -----Original Message----- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 3 April 2002 5:39 PM To: CF-Talk Subject: Re: Exporting data to Excel spreadsheet Try CF_Query2Excel tag - works very well if you can't find it on Macromedia send me another email - I've got a copy here somewhere Seamus At 05:23 pm 3/04/02 , you wrote: >At one of my clients, the content providers each look after an allocated >part of the data used for displaying information on the web site. They >want to be able to export their data to a spreadsheet so they can review >it and update it off line. These are not IT people but experts in their >various consumer fields. They want me to put a button in their admin >areas for each category of comsumer data so it will export the data for >them automatically. I was going to do it this way and I wondered if there >was a better way: > > >(1) Have a spreadsheet already attached to CF as a datasource. >(2) Use a CFQuery to delete all the records in that datasource. >(3) CFQUERY the SQL7 table the content provider wants to export >(4) loop through the query, inserting the data into the (now blank) >spreadsheet. >(5) Use CFMail to email the spreadsheet to the user (getting their email >address from their logon details). > >I seem to remember a function or a tag that output the results of a query >into spreadsheet format but I can't find any reference to it any more. >Can anyone enlighten me? > > >Is this the easiest way? Will CFMail be able to send the spread sheet or >will I need to unlock it from the server first? in which case, how can i >do that automatically? > > >Cheers, >Mike Kear >AFP Webworks, >Windsor, NSW, Australia > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
