Even better...the Apache Jakarta project as a set of Java classes that can read/create/modify/delete office docs...including Excel. It is called POI. In testing that I did at a former client, this process blows the pants off of using an Excel com object. We testing this with the com object on a dual processor box and the POI code on a single processor box (the processors were all the same speed and both boxes had the same amount of memory and plenty of drive space and they were producing the same report). The com object maxed out the processors for about 20 seconds...obviously stopping anything else from happening on the box. The POI code blipped for about 4 seconds and was done. If you do a search on CF and POI, you will find a site (d-ross.org I think) that shows you how to do this in CF.
Eric -----Original Message----- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 January 2007 07:28 To: CF-Talk Subject: Re: Reading from an Excel file through ColdFusion. Here is a tag that will do just what you would like...hope it helps http://www.emerle.net/programming/display.cfm/t/cfx_excel2query Doug B. ----- Original Message ----- From: "hussain shaikh" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, January 30, 2007 4:51 AM Subject: Reading from an Excel file through ColdFusion. > Hi, > I want to read and parse through the excel files from coldfusion. > Banged my head on the net but couldn't find anything :-( > Even in CF documentation it's nowhere mentioned about reading an excel file from CF. > This is the last hope of finding a solution. > > Thanks in advance. > Hussain. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
