Readtable don't work correctly if 'Range' > 'A250'

The command readtable('DruckTest.xlsx','Range','A251') works as expected:

>> Ta = readtable('DruckTest.xlsx','Range','A250');size(Ta),Ta(end,:)
ans =
51     2
ans =
1×2 table
Var1        Var2
___________    ____
07-Mar-2021    1.1 

The command readtable('DruckTest.xlsx','Range','A251') issues a strange result:

>> Ta = readtable('DruckTest.xlsx','Range','A251');size(Ta),Ta(end,:)
ans =
0     0
ans =
1×0 empty table

What am I doing wrong? I attached the xlsx. Thanks in advance.

Answer 1

[Adam Danz]

Update: The 250 line limitation is no longer a problem starting in MATLAB R2023a. Thanks for reporting this.

Workaround prior to R2023a

That doesn't sound good.

If you manually grab the import options, that addresses the problem.

opts = spreadsheetImportOptions('DataRange','A251');
Ta = readtable('DruckTest.xlsx',opts)

[Alexander]

Thank you Adam, this works. Best regards, Alex.