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 (
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


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