Unable to open .csv file ("Error using importdata (line 136) Unable to open file")
4 次查看(过去 30 天)
显示 更早的评论
Hello!
I am using a loop to open a big number of .csv files. I have applied it to a folder with .csv files and it worked. However,I apply it now to another folder with .csv files and it doesn't work.
The loop is the following:
dd = dir('C:\Users\...\csv');
n=numel(dd);
for k=3:n;
filename=dd(k).name;
A=importdata(filename);
...
end
Any idea why it is not working? Thank you in advance!
0 个评论
回答(2 个)
Azzi Abdelmalek
2014-4-28
dd = dir('C:\Users\...\*.csv');
n=numel(dd);
for k=3:n;
filename=dd(k).name;
A{k}=importdata(filename);
...
end
Image Analyst
2014-4-29
If the only difference is the folder and the particular csv files, then perhaps one is corrupted . Can you attach the one that it bombs on?
8 个评论
Image Analyst
2014-5-4
Well what must have happened is that in the first case where it ran, you must have had the csv files in the current folder so you didn't need the folder name. In the second case the files were not in the current folder, where the m-file was, or even on the search path. So it didn't know where to find them. When you added
filename=[char2 char1];
now you told it the full filename and it could find them. The proper way, more robust way , to do this is:
folder = 'C:\Users\...\csv\';
if exist(folder, 'dir')
for k=3 : n
fullFileName= fullfile(folder, d(k).name);
if exist(fullFileName, 'file')
A=importdata(fullFileName);
end
end
else
errorMessage = sprintf('Error: folder does not exist:\n%s', folder);
uiwait(warndlg(errorMessage));
end
I suggest you make these changes to improve your code.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!