what a sign for this error ?

2018 8 29
1 个回答
更新时间：2021 8 20
4 次查看（30 天）

0 个投票

Hello guys
does anyone know which part is wrong?

回答（1 个）

Greg
Greg 2018-8-29

0 个投票

There's not a lot to go on, but my only guess is you don't have MS Office Excel installed on a Windows machine. Without Excel installed, xlsread operates in 'basic' mode, which does not support the numeric worksheet input. Considering no sheet number input defaults to the first worksheet, simply try:
xlsread(fileread);

3 个评论
显示 1更早的评论 隐藏 1更早的评论

thank you for your response @greg, ms excel has been installed in my windows. sometimes the code is successful and sometimes error. do you know other causes? the code line in my opinion is no error, isn't that right?
Dennis
Dennis 2018-8-30
Can you elaborate when the error occurs and on which files?
Also xlsread will not work if the file is opened in Excel.
Greg
Greg 2018-8-30
编辑：Greg 2018-8-30
"Also xlsread will not work if the file is opened in Excel."
I just tested that explicitly this morning and it does in fact work. At least with whatever edition of Excel I have (2013? maybe), and R2017b on Win10.
I also checked having a file with no worksheets, but Excel won't let you do that. Maybe if some other application created a .xls file with no sheets...

此问题已关闭。

标签

关闭：

MATLAB Answer Bot
MATLAB Answer Bot
2021-8-20

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by