Why do i get an error when using readtable saying cannot open file

210 次查看（过去 30 天）

LM 2017-10-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/361077-why-do-i-get-an-error-when-using-readtable-saying-cannot-open-file

评论： Image Analyst 2023-1-5

E85C1B5D-8CF4-4369-B851-42988BD3DD78.png

Error using readtable (line 198) Unable to open file ‘equity_dataset_30_2.csv’.

I have made sure i have used the file name correctly and imported the data. I have tried fixing the error but cannot get rid of it.

14 个评论
显示 12更早的评论隐藏 12更早的评论

Benjamin Robistow 2018-11-2

编辑：Walter Roberson 2020-6-11

在 MATLAB Online 中打开

Try using the following it will get the whole path and make the selection a little more dynamic.

curr_dir = dir;
[filename, pathname] = uigetfile('*.csv');
T = readtable(strcat(pathname,filename));
cd(curr_dir);

This will solve the issue incase you are trying to use a file that is nested or located somewhere that isn't in the current working directory

Walter Roberson 2018-11-2

在 MATLAB Online 中打开

You cannot cd to the result of dir() . You can cd to the result of pwd(), but there is no point in doing so because using uigetfile() and readtable() do not change the working directory.

 [filename, pathname] = uigetfile('*.csv');
 T = readtable(strcat(pathname,filename));

There is no promise that the path returned by uigetfile() will end in a terminator, so you should not use strcat() between the parts: use fullfile(pathname, filename)

请先登录，再进行评论。

请先登录，再回答此问题。

回答（3 个）

Image Analyst 2017-10-13

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/361077-why-do-i-get-an-error-when-using-readtable-saying-cannot-open-file#answer_285718

在 MATLAB Online 中打开

It's probably that unneeded 'format' option. It works fine without it. Try this, which is more robust than what you have:

baseFileName = 'equity_dataset_30_2.csv';
folder = 'C:/users/Apple/Desktop/MATLAB/Individual Coursework/Q1';
fullFileName = fullfile(folder, baseFileName)
if exist(fullFileName, 'file')
  % File exists.  Read it into a table.
  t = readtable(fullFileName)
else
  % File does not exist.  Warn the user.
  errorMessage = sprintf('Error: file not found:\n\n%s', fullFileName);
  uiwait(errordlg(errorMessage));
  return;
end

4 个评论
显示 2更早的评论隐藏 2更早的评论

LM 2017-10-13

编辑：LM 2017-10-13

Screenshot 2017-10-13 21.26.57.png

The file is inside C:/users/Apple/Desktop/MATLAB/Individual Coursework/Q1.

Here is another screenshot

Walter Roberson 2017-10-13

Your screenshots are from a Mac, not Windows. You do not have a C: . You should remove the 'C:' from your file name.

请先登录，再进行评论。

Neel Khakhar 2020-6-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/361077-why-do-i-get-an-error-when-using-readtable-saying-cannot-open-file#answer_449747

Try using path(pathdef) and cd to desired path. If the file is also shared on a server, it might be locked/lost by source control. I faced a similar issue intermittently while working on my project. It helped.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2020-6-11

Her screenshot shows she did call cd() to the folder where she thought the CSV file lived.

It's possible that the file just isn't there or locked for some reason. Maybe someone else is actively editing it??? With Windows, it will tell you if someone else has it locked and offer to let you open a read-only copy.

One thought is that she misspelled Individual as Indvidual when she called cd(), but that should have thrown an "Error using cd" error, so maybe it is actually misspelled.

Another thought is that in readtable() she used 'equity_dataset_30-2.csv' while in the comment she said that she was planning on reading in 'equity dataset 30.csv'. Not sure which of those two filenames is the actual, correct filename. Should it have underlines and a -2, or not??? But that is another discrepancy.

请先登录，再进行评论。