Use cfspreadsheet to read it from it's current location.
Unfortunately, this client is not in my hosting environment, which is CF9. They are on an inferior host which has them on CF6 (yuck!).
Find Ben Nadel's poi for getting coldfusion to play with excel. I know it works on v7. It might work on v6 also.
Thanks. I have used his utility in the past and loved it. I am having difficulties in getting it to read a remote file though.
Can you programmically retrieve it using CFFTP?
Here is a simple example...
<cfftp connection="#session.sessionID#" action="getfile" remotefile="#form.myget#" localfile="#scriptdir#/stuff/#form.myget#" transfermode="binary"
timeout="30" retrycount="3" stoponerror="no" failifexists="no">
<cfif cfftp.errorcode is not 0>
Attempt to get #form.myget# failed.
Got <cfoutput>#form.myget#</cfoutput> OK.
<cfhttp....> can be used to get excel file nearly the same as it can get the HTML content.
The documentation should give you the details.
What sort of difficulties are you having? File not found? Not enough permission?
I was able to successfullly download the excel file using cfhttp. (Thanks, Ian).
Now I am attempting to use Ben Nadel's POI utility (which I have used before with success) to read it. I am running into the following error...
What does this mean? Is it because their host is not on a high enough level?
I was able to successfully retrieve and manipulate the data from the external page using cfhttp and parsing through the filecontent to get the info I needed. Thanks for your assistance.