xlsread error, wont open file

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)');

[Anthony Voccia]

I figured it out, I was using a combination of two different methods. This is what it should have been

A1 = xlsread(fullpath,'A2:A16');

[Star Strider]

If I remember correctly, that was essentially the solution I gave in my my Answer.

Answer 1

[Star Strider]

A guess:

A1 = xlsread(fullpath,1,'A2:A16');
B1 = xlsread(fullpath,1,'B2:B16')*1E-3;

Answer 2

[madhan ravi]

Make sure Prelab excel file is there in the path as the error message clearly states that there is no such file

[Anthony Voccia]

That is why I am confused because the file is there. I use the same file to store the other excel documents and they work fine

Answer 3

[Luna]

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)