Error using xlsread with MatLabR2020b

1 回表示 (過去 30 日間)
Filippo Bocchi
Filippo Bocchi 2020 年 11 月 16 日
回答済み: Sourabh Kondapaka 2020 年 11 月 19 日
Basically, when I run the xlsread function, it seems that I can't read more than 108 array elements on an Excel File.
>> [num, txt, raw] = xlsread (infile, 'A100:A2000');
Error using xlsread (line 257)
Index exceeds the number of array elements (108).
  1. Is there a way to fix this?
  2. Why I'm experiencing this problem?
  1 件のコメント
Matt Derosier
Matt Derosier 2020 年 11 月 16 日
I'm currently helping someone in a lab with xlsread issues and readmatrix is what Mathworks is recommending for anything after 2019a (https://www.mathworks.com/help/matlab/ref/xlsread.html).
Hope this helps you as well!

サインインしてコメントする。

サインインしてこの質問に回答する。

回答 (1 件)

Sourabh Kondapaka
Sourabh Kondapaka 2020 年 11 月 19 日
Hi Filippo Bocchi,
As Matt Derosier had suggested , avoid using the xlsread function. On achieving what you wanted with readtable() function please check the Compatibility Considerations sections of this link

カテゴリ

Help Center および File Exchange で Logical についてさらに検索

タグ

製品

Community Treasure Hunt

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

Start Hunting!

Translated by