Yeah, and some of the code is great, my problem is what when trying to create/connect to an Excel COM object, it pops an error half the time. Sometimes it will work beautifully, I'll set it aside, come back in 2 hours, test it again, and it won't work. I don't know if it's a configuration issue or just a general lack of stability in using an instance of Excel in that fashion, but I just couldn't get it strong enough to use it on a regular basis.
At 03:53 PM 6/5/2003 -0400, you wrote: >Have you checked out http://www.cfcomet.com/ yet? > >E > >----- Original Message ----- >From: "Cassidy Symons" <[EMAIL PROTECTED]> > > >I'm looking for suggestions on the most efficient to write an XLS file via >ColdFusion. I've tried COM objects (not stable enough for regular use), >HTML tables being read in Excel (too slow for the quantities of data in >question), and using an Excel datasource (a pain in the ass since this is >based upon a dynamic query statement that could be coming from a number of >different tables, with any number of columns). Is there some obvious trick >I'm missing, or am I going to be pulling my hair out looking for something >stable and reasonably fast. > >Thanks > > >Cassidy > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4