xlsread unable to open file

Question

Anthony Voccia 2018-9-20

评论： Anthony Voccia 2018-9-20

I have been messing with this for a while now but have no clue what to change. The error is in line 4, any ideas?

Answer 1

Stephan 2018-9-20

编辑：Stephan 2018-9-20

Hi,

path = 'C:\Users\Stephan\Desktop';
filename = 'test.xlsx';
fullpath = [path, '\', filename];
data = xlsread(fullpath,'A1:B2');

is one possibility of solving this problem.

Also join would work:

path = "C:\Users\Stephan\Desktop";
filename = "test.xlsx";
fullpath = join([path, filename],"\");
data = xlsread(fullpath,'A1:B2');

Note that double quotes are used now.

Best regards

Stephan

Anthony Voccia 2018-9-20

Thanks! I used the first one and modified data= and elong= which made them both work.