I've never done excel processing with CF as we just save the file as tab delimited and read it in as text. I wonder if you can set up some sort of datasource to the excel object through windows dsn and do it that way...
Also can try getting a copy of fusiondebug and stepping through the code. Russ > -----Original Message----- > From: Robert Harrison [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 07, 2006 5:04 PM > To: CF-Talk > Subject: RE: HELP: Speeding up a Collection > > > I could start putting things like : "DONE" <cfabort /> at differt parts > of > the code (of course don't > > actually update the database). See if you can narrow down which part of > the algorithm is taking a long time. > > Been there and done that ALL DAY... The bottle neck lies either here: > > <CFSET objRange= > objSheet.Range("A#cnt#,B#cnt#,C#cnt#,D#cnt#,E#cnt#,F#cnt#,G#cnt#,H#cnt#,I# > cn > t#,J#cnt#,K#cnt#,L#cnt#,M#cnt#")> > > or here: > > <cfset > record[#listgetat(column_headers,collection_cnt,",")#] = this.text> > > I suspect the latter. It seems like Excel is extreamly slow, but this is > 2006. CF should have no problem parsing an Excel sprearsheet even it has > thousands of records. > > Thanks, > > Robert Harrison > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259540 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
