Clear Filters
Clear Filters

xlsread unable to open file

24 views (last 30 days)
Anthony Voccia
Anthony Voccia on 20 Sep 2018
Commented: Anthony Voccia on 20 Sep 2018
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?

Accepted Answer

Stephan
Stephan on 20 Sep 2018
Edited: Stephan on 20 Sep 2018
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
  1 Comment
Anthony Voccia
Anthony Voccia on 20 Sep 2018
Thanks! I used the first one and modified data= and elong= which made them both work.

Sign in to comment.

More Answers (0)

Categories

Find more on Programming in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!