Trouble with code to check for Excel file existence

5 ビュー (過去 30 日間)
Douglas Anderson
Douglas Anderson 2012 年 6 月 4 日
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

採用された回答

Walter Roberson
Walter Roberson 2012 年 6 月 4 日
if exist(file_name,'file') == 0

その他の回答 (1 件)

Douglas Anderson
Douglas Anderson 2012 年 6 月 4 日
One quick comment: I know that it isn't a path problem

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by