Hi Andrew,
Thanks... Excel isn't involved as the file is being delivered via email. I need
to read it in and process the contents - sadly other formats are not available.
I worked out that CFXL could read the file and found the rows but something in
the format of the file meant that it could not read the cells...
I'm now working on a two step approach to convert the file to CSV when it is
delivered and then process the content... Its clunky and I hate cfexecute but
it seems I have no choice right now.
B)
Andrew Scott wrote:
Brett,
The most common mistake that people tend to make, and I am hoping this is
not something that you are doing. Is that ColdFusion can't load the
spreadsheet with whatever means you are trying, unless you close the
spreadhseet in Excel.
By the sounds of it this might be what is happening.
Regards,
Andrew Scott
http://www.andyscott.id.au/
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On
Behalf Of Brett Payne-Rhodes
Sent: Sunday, 25 July 2010 2:50 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Read an Excel spreadsheet...
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
--
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.
