How to import an excel file from the web?

I would like to import an excel spreadsheet which is on the intranet. I can click the file to download it when I am on that page. Now I am able to read the source code of that page using 'urlread', but not sure how to open the actual file.

Any clue?

Thanks,

Feng

Answer 1

[Walter Roberson]

xlsread()

[Feng]

Thanks for the response. How do I refer the file on the internet?

[Walter Roberson]

urlread() of the download page will allow you to find the URL of the file itself; it will probably be in the form of a file: URL or possibly an http: or https: URL. Once you have extracted that URL, urlread() or urlwrite() the file itself.

Answer 2

[Jan]

You can use URLREAD to read the Excel file, store it locally and use XLSREAD then.

Walter 's idea is better: urlwrite performs the storing to disk implicitly.

[Walter Roberson]

urlwrite() might make more sense than urlread() in this circumstance.