MATLAB Answers

Error using xlsread with MatLabR2020b

1 view (last 30 days)
Filippo Bocchi
Filippo Bocchi on 16 Nov 2020
Answered: Sourabh Kondapaka on 19 Nov 2020
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 Comment

Matt Derosier
Matt Derosier on 16 Nov 2020
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!

Sign in to comment.

Answers (1)

Sourabh Kondapaka
Sourabh Kondapaka on 19 Nov 2020
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

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by