Thanks Steve,
If I had more understanding of the excel version then I might be tempted to go
down this track but I can just imagine the fun given I think it is an xls file
generated on the fly.
And while I have MSSQL for development work I don't have it on the production
server - M$ already takes enough of my money.
B)
Steve Onnis wrote:
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:Driver={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/WSc3ff6d0ea77859461172e0811cbec17cba-7f87.html
On 25 July 2010 12:50, Brett Payne-Rhodes <bret...@gmail.com
<mailto: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 <mailto: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 cfaussie@googlegroups.com
<mailto:cfaussie@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*
<webonix:net strength="Industrial" /> <http://webonix.net> |
<webonix:org community="Open" /> <http://webonix.org>
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.
--
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.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.