"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.
23 次查看(过去 30 天)
显示 更早的评论
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/170071/image.png)
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');
3 个评论
杨
2024-7-22
移动:Fangjun Jiang
2024-7-22
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.
回答(1 个)
Fangjun Jiang
2018-2-8
You have the Excel file in that folder but do you have a sheet named "Sheet1" in that Excel file?
8 个评论
Walter Roberson
2018-2-9
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
2018-2-9
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!