"Error using xlsread, Worksheet 'Sheet1' not found. " I have this eror and I don't know why. I have the sheet and it's in the folder which I have my script and functions.

I attached the eror in Png

Error using xlsread (line 247) Worksheet 'Sheet1' not found.

Error in load_the_prediction_data (line 15) [~,Times]=xlsread(['dee1_' char(Current_time_stamp) '.xlsx'],'Sheet1','A:A');

[Bob Thompson]

Are you sure it's finding the correct file?

[javad amoli]

yes

[杨]

The same to me,how the author solve this problem?

I have tried to read the <ExcelFileName> separately, and it was OK.

This indicates that the <ExcelFileName - sheet1> in this folder can be read, but it cannot be successfully read when <main .m> file is running.

Answer 1

[Fangjun Jiang]

You have the Excel file in that folder but do you have a sheet named "Sheet1" in that Excel file?

[javad amoli]

can you explain more plz?

[Fangjun Jiang]

The error message indicates that the Excel file is found but in that Excel file, "Sheet1" is not found.

Your question "I have the sheet and it's in the folder" indicates that you think "sheet" is the Excel file.

So, open that Excel file outside of MATLAB. If you don't see the "Sheet1" sheet (or tab), then that is the problem.

[Walter Roberson]

Also, you can use the second output of xlsinfo() to see what sheets are present.

[javad amoli]

but here I have the sheet1 . what is wrong ?

[Walter Roberson]

What is returned by

filename = ['dee1_' char(Current_time_stamp) '.xlsx'];
[~, sheets] = xlsinfo(filename)

and what happens if you then try

[~, Times] = xlsread(filename, 1);

[javad amoli]

this eror "Undefined function or variable 'Current_time_stamp'."

[Walter Roberson]

At the command line command

dbstop if error

and run the program. When it stops, use the command dbup as many times as needed until it tells you that you are in the workspace of load_the_prediction_data

At that point run the xlsinfo command I showed.

[Fangjun Jiang]

Your showed dee1.xlsx but your code was looking for dee1_***.xlsx. So it is not the right file.

Just locate that file, run xlsread(ExcelFileName,'Sheet1','A:A') to see what happens. This command will run without error, return an empty array with just a new dummy empty Excel file.