Trouble with code to check for Excel file existence

4 ビュー (過去 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 ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by