Importing data from an Excel file on a website

2011 10 5
2 个回答
9 次查看（30 天）

0 个投票

I am trying to import data from an Excel file on a website (Subversion Repository). I tried and failed with:
PATHNAME_KEY = 'http://XXsvn/XXXXX/XXXXX/XXXXX/XXXXX/'; FILENAME_KEY = 'Key.xlsx';
cd(PATHNAME_KEY)
With Error:
??? Error using ==> cd Cannot CD to http://XXsvn/XXXXX/XXXXX/XXXXX/XXXXX/ (Name is nonexistent or not a directory).
Error in ==> Classification at 66 cd(PATHNAME_KEY)

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

回答（2 个）

Fangjun Jiang
Fangjun Jiang 2011-10-5

0 个投票

Of course you can not run cd(PATHNAME_KEY) because that url is not a directory. I wonder if you can run
xlsread(fullfile(PATHNAME_KEY,FILENAME_KEY))

2 个评论
显示 无 隐藏 无

Brian
Brian 2011-10-5
Now, the error is:
??? Error using ==> xlsread at 214
XLSREAD unable to open file
http:\\XXsvn\XXXXX\XXXXX\XXXXX\XXXXX\Key.xlsx.
File http:\\XXsvn\XXXXX\XXXXX\XXXXX\XXXXX\Key.xlsx not found.
Error in ==> Classification at 60
[~,~,raw_KEY] =
xlsread(fullfile(PATHNAME_KEY,FILENAME_KEY),'Key');
Fangjun Jiang
Fangjun Jiang 2011-10-5
Then I guess you can't read an .xls file directly from a web site. You have to download the file first and then read it. That's part of the "http". Web browser can interprets it and get the content using whatever protocol, but not for xlsread().

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2011-10-5

0 个投票

You will need to use urlread() or (probably better for your purpose) urlwrite() .

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

提问:

Brian
Brian
2011-10-5

Community Treasure Hunt

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

Start Hunting!

Translated by