Readtable don't work correctly if 'Range' > 'A250'
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Alexander
am 1 Jul. 2022
Bearbeitet: Adam Danz
am 17 Mär. 2023
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.
0 Kommentare
Akzeptierte Antwort
Adam Danz
am 1 Jul. 2022
Bearbeitet: Adam Danz
am 17 Mär. 2023
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)
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!