Info

此问题已关闭。 请重新打开它进行编辑或回答。

what a sign for this error ?

1 次查看(过去 30 天)
Muhammad Dzul  Akbar
关闭: MATLAB Answer Bot 2021-8-20
Hello guys
does anyone know which part is wrong?

回答(1 个)

Greg
Greg 2018-8-29
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 个评论
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...

Community Treasure Hunt

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

Start Hunting!

Translated by