How to import an excel file from the web?

Question

Feng 2013-1-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58563-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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2013-1-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/58563-how-to-import-an-excel-file-from-the-web#answer_70862

xlsread()

2 个评论
显示无隐藏无

Feng 2013-1-11

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

Walter Roberson 2013-1-12

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.

请先登录，再进行评论。