Trouble importing data from excel file using xlsread
10 views (last 30 days)
Show older comments
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.
0 Comments
Accepted Answer
Jiro Doke
on 20 Feb 2011
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.
0 Comments
More Answers (2)
Walter Roberson
on 20 Feb 2011
I don't know, but I would suggest experimenting with
[fid, status] = fopen('C:\Documents\oput021m.xls','rt');
and then examining the status variable.
0 Comments
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!