Info

この質問は閉じられています。 編集または回答するには再度開いてください。

what a sign for this error ?

1 ビュー (過去 30 日間)
Muhammad Dzul  Akbar
Muhammad Dzul Akbar 2018 年 8 月 29 日
終了済み: MATLAB Answer Bot 2021 年 8 月 20 日
Hello guys
does anyone know which part is wrong?
  1 件のコメント
Greg
Greg 2018 年 8 月 30 日
What does
which xlsread
return?

回答 (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 件のコメント
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