Trouble importing data from excel file using xlsread
显示 更早的评论
I am having trouble importing data from excel file using xlsread. I attempt as follows:
ndata = xlsread('C:\Documents\oput021m.xlsx', 'F2:F3');
And get the following error:
??? Error using ==> xlsread at 219 XLSREAD unable to open file C:\Documents\oput021m.xlsx. File C:\Documents\oput021m.xlsx not found.
I have even tried opening a file with the .xls extension and continue to get the same error. The file is in the location that is specified, so I am not sure what is going wrong. Could someone please help me out? Thanks.
采纳的回答
Jiro Doke
2011-2-20
What do you get when you type
exist('C:\Documents\oput021m.xlsx', 'file')
Does it return 2? If 0, then you mistyped the filename. Make sure you have the correct extension. For Excel files, it could also be .xlsm, .xls, .xlsb.
更多回答（2 个）
Walter Roberson
2011-2-20
I don't know, but I would suggest experimenting with
[fid, status] = fopen('C:\Documents\oput021m.xls','rt');
and then examining the status variable.
类别
在 帮助中心 和 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 
