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 Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by