xlsread error, wont open file

20 次查看（过去 30 天）
Anthony Voccia
Anthony Voccia 2018-11-15
评论： Star Strider 2018-11-15
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)');
  2 个评论
Anthony Voccia
Anthony Voccia 2018-11-15
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
Star Strider 2018-11-15
If I remember correctly, that was essentially the solution I gave in my my Answer.

请先登录，再进行评论。

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

回答（3 个）

Star Strider
Star Strider 2018-11-15
A guess:
A1 = xlsread(fullpath,1,'A2:A16');
B1 = xlsread(fullpath,1,'B2:B16')*1E-3;
madhan ravi
madhan ravi 2018-11-15
Make sure Prelab excel file is there in the path as the error message clearly states that there is no such file
  1 个评论
Anthony Voccia
Anthony Voccia 2018-11-15
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

请先登录，再进行评论。

Luna
Luna 2018-11-15
编辑：Luna 2018-11-15
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)

类别

在 Help Center 和 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