Error in XLS Read

1 view (last 30 days)
Shady Elsayed
Shady Elsayed on 13 May 2020
Commented: Walter Roberson on 14 May 2020
Im am prompted to enter an excel sheet filename then use xlsread to display it on the matlab
I have tried using
F=input('Enter filename')
A=xlsread(F)
But whenever I run the program I receive a message saying that filename was not found even though it works with every other command and I carefully checked the spelling
  1 Comment
Walter Roberson
Walter Roberson on 14 May 2020
F=input('Enter filename ', 's');

Sign in to comment.

Answers (1)

Geoff Hayes
Geoff Hayes on 14 May 2020
Shady - perhaps you need to supply the path to the file? Is the file in the MATLAB search path? Consider using uigetfile so that the user can choose the file that she wants to open. Your code may look something like
[file,path] = uigetfile('*.xlsx')
A=xlsread(fullfile(path,file));

Community Treasure Hunt

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

Start Hunting!