Trouble with code to check for Excel file existence

7 vues (au cours des 30 derniers jours)
Douglas Anderson
Douglas Anderson le 4 Juin 2012
Hello!
xlsread() goes through a bunch of machinations before it tells you that the file doesn't exist if you mistyped the file name. I wrote the simple script to check if the file exists:
while exist('file_name','file') ~= 2
filename_root = input('File name (no xlsx)','s');
file_name = [filename_root,'.xlsx'];
end
disp('Success');
This way I could simply loop to correct an obvious misspelling. This doesn't work. I tried this:
filename_root = input('File name (no xlsx)','s');
file_name = strcat(filename_root,'.xlsx');
if exist('file_name','file') == 0
disp('Not found');
else
disp('Success');
end
and never got to "Success". Any thoughts?
Thanks!
Doug A

Réponse acceptée

Walter Roberson
Walter Roberson le 4 Juin 2012
if exist(file_name,'file') == 0

Plus de réponses (1)

Douglas Anderson
Douglas Anderson le 4 Juin 2012
One quick comment: I know that it isn't a path problem

Catégories

En savoir plus sur Get Started with MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by