Skip to main content
WebolutionDesigns
Known Participant
June 18, 2010
Question

Reading Excel file from another site

  • June 18, 2010
  • 3 replies
  • 1345 views

I have a client who wants to put information on their site that is on a third party site (we have permission). Ideally, I would love to use RSS, but this site does not have that option. There are two methods the info is available...1) within a table on the page and 2) within an excel file via a link on the page.

I looked at using cfhttp to screen scrape, but do not want my code to break if they redesign their page. So I thought if I could somehow pull the Excel file and then read it, that would be perfect. I have read info from Excel files before, so I have no problems there (I hope), but where I need assistance is pulling the file from the site. I was thinking that if I could use some sort of combination of cffile and cfschedule to pull it and put it on my server, that would be ideal. Has anyone ever done anything like this before?

Thoughts? I am open to alternatives too.

Thanks,

Clay

This topic has been closed for replies.

3 replies

WebolutionDesigns
Known Participant
June 28, 2010

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.

ilssac
Inspiring
June 22, 2010

<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.

Inspiring
June 19, 2010

Use cfspreadsheet to read it from it's current location.


WebolutionDesigns
Known Participant
June 20, 2010

Unfortunately, this client is not in my hosting environment, which is CF9. They are on an inferior host which has them on CF6 (yuck!).

Inspiring
June 20, 2010

Find Ben Nadel's poi for getting coldfusion to play with excel.  I know it works on v7.  It might work on v6 also.