I like jExcel. You could try this simple script with jExcel(instantiated with javaLoader):
<!--- path to Excel sheet ---> <cfset filepath = "C:\Inetpub\wwwroot2\tryExcel_CF.xls"> <cfscript> wfile = createObject("java","java.io.File").init(filepath); workbookPai = server.javaLoader.create("jxl.Workbook"); wworkbook = server.javaLoader.create("jxl.write.WritableWorkbook"); wworkbook = workbookPai.getWorkbook(wfile); sheetPai = server.javaLoader.create("jxl.write.WritableSheet"); //get sheet named cf_xl_integration - change to the name in your workbook sheet = wworkbook.getSheet("cf_xl_integration"); </cfscript> <cfset rowslen = sheet.getRows()> <cfset columnslen = sheet.getColumns()> <cfoutput> <cfloop from="0" to="#columnslen-1#" index="c"> #sheet.getCell(javacast('int',c),0).getContents()# <br /> </cfloop> </cfoutput> Will need to download jExcel.jar and include in your directory for this script. Cheers Marco Antonio On Wed, Feb 13, 2008 at 10:54 PM, Jaime Metcher < [EMAIL PROTECTED]> wrote: > Brian, > > I would also recommend POI with Ben Nadel's POIUtility, but if you want to > stick with a DSN, the following includes a way to unlock the datasource: > > > http://cfregex.com/cfcomet/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9 > 004033E03EF9<http://cfregex.com/cfcomet/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9> > > No idea if it still works in CFMX 6/7/8. > > Jaime Metcher > > > -----Original Message----- > > From: Brian Dumbledore [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 14 February 2008 2:05 AM > > To: CF-Talk > > Subject: Reading Excel.. > > > > > > I made the subject look easy so I can have more viewers ;) But > > here is my problem.. After having trouble with working > > cfx_Excel2Query ( I finally reverted to it in the end and got it > > working), I thought why not do this: > > > > 1) Create a odbc dsn to a excel file > > 2) Create a cf dsn to this odbc dsn > > 3) User uploads his file, I copy it as the file to which the dsn > > si specified. > > 4) I query the file using [sheet$1] as the table, and so on. > > > > > > This method works fine, however, sometimes (most of the times), > > it appears the file being used as the dsn gets 'locked'. I cann't > > delete, rename etc, 'next' upload of file fails to overwrite this > > file because it is locked. > > Basically this method is too inconsistent. > > > > My question is, is there anything I need to do to make sure the > > file is 'released' after the query has run? If this one thing is > > solved, I no longer have to use third party solutions, I can just > > create a dsn to the file and keep overwriting the file with the > > new file whenever. > > > > Any suggestions? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4