What database platform are you using? Because you can use SQL to do it if you are using MSSQL see http://blog.cfcentral.com.au/post.cfm/reading-excel-spreadsheets Or you can use JAVA to do it also c = CreateObject("java","java.sql.DriverManager").getConnection("jdbc:odbc:Drive r={Microsoft Excel Driver (*.xls)};DBQ=" & [filename] ); stmnt = c.createStatement(); rs = stmnt.executeQuery(Select * from [Sheet1$]); myQuery = CreateObject('java','coldfusion.sql.QueryTable').init(rs); } I have used both and both seemed to work well. You just have to make sure you have the right drivers for the xls version you are playing with. Steve
_____ From: AJ Mercer [mailto:ajmer...@gmail.com] Sent: Tuesday, 27 July 2010 12:39 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Read an Excel spreadsheet... what version of excel is the file? What version of CF are you using? CF9 has cfspreadsheet http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e08 11cbec17cba-7f87.html On 25 July 2010 12:50, Brett Payne-Rhodes <bret...@gmail.com> wrote: Hi, I'm looking at the options to read an excel spreadsheet and despite all the good stuff I have found from people like Ben Nadal and Charlie Arehart nothing seems to want to work 'as advertised'. I headed down the path of using Java and the POI library via Ben's POIutility.cfc but couldn't get it to read the file - dunno why, it was a weird java error. I then tried CFXL by Jason Delmore and while I can get that to read the demo excel file it won't read the one I need it to read. I know there are a few more options but I was just wondering if anyone here had done this before and could let me know what worked for them... Many thanks, Brett B) -- Brett Payne-Rhodes YourSite Web Solutions w: http://www.yoursite.net.au e: br...@ehc.net.au t: +61 (0)8 9371-0471 m: +61 (0)414 371 047 -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com <mailto:cfaussie%2bunsubscr...@googlegroups.com> . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- AJ Mercer <http://webonix.net> <webonix:net strength="Industrial" /> | <http://webonix.org> <webonix:org community="Open" /> http://twitter.com/webonix -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
