Readtable don't work correctly if 'Range' > 'A250'
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Alexander
el 1 de Jul. de 2022
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 comentarios
Respuesta aceptada
Adam Danz
el 1 de Jul. de 2022
Editada: Adam Danz
el 17 de Mzo. de 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)
Más respuestas (0)
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!