Importing data from an Excel file on a website

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)

Answer 1

[Fangjun Jiang]

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

[Brian]

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]

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

Answer 2

[Walter Roberson]

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