How to import an excel file from the web?

14 次查看（过去 30 天）
Feng
Feng 2013-1-11
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

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

采纳的回答

Walter Roberson
Walter Roberson 2013-1-11
xlsread()
  2 个评论
Feng
Feng 2013-1-11
Thanks for the response. How do I refer the file on the internet?
Walter Roberson
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.

请先登录，再进行评论。

更多回答（1 个）

Jan
Jan 2013-1-12
编辑：Jan 2013-1-12
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by