Error using xlsread with MatLabR2020b

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?

[Matt Derosier]

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!

Answer 1

[Sourabh Kondapaka]

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