xlsread error, wont open file
5 views (last 30 days)
Show older comments
Error using xlsread (line 139)
XLSREAD unable to open file 'Prelab'.
File 'Prelab' not found.
Error in Prelab (line 5)
A1 = xlsread('Prelab',1,'A2:A16');
I have used this method a few times now but it is not working for this file, any ideas?
clc, clear, close all;
path = 'C:\Users\Anthony\Desktop\220 Lab' ;
filename = 'Prelab.xlsx' ;
fullpath = [path, '\', filename];
A1 = xlsread('Prelab',1,'A2:A16');
B1 = xlsread('Prelab',1,'B2:B16')*10^-3;
plot(A1,B1);
xlabel('load (gr-Kg-lbs');
ylabel('Deflection (in)');
title('Load (gr) vs. Deflection (in)');
Answers (3)
Star Strider
on 15 Nov 2018
A guess:
A1 = xlsread(fullpath,1,'A2:A16');
B1 = xlsread(fullpath,1,'B2:B16')*1E-3;
0 Comments
madhan ravi
on 15 Nov 2018
Make sure Prelab excel file is there in the path as the error message clearly states that there is no such file
Luna
on 15 Nov 2018
Edited: Luna
on 15 Nov 2018
Hello Anthony
check the inputs of xlsread function.
First input should be the full file name with path or if your matlab‘s current path is the same directory that contains your excel, the first input can be the file name with its extension.
For example:
xlsread(‘C:\Users\Desktop\myExcel.xls’,.. etc)
xlsread(‘myExcel.xls’,etc)
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!