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

2 次查看（过去 30 天）
Alexander
Alexander 2022-7-1
编辑： Adam Danz 2023-3-17
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.

请先登录，再回答此问题。

采纳的回答

Adam Danz
Adam Danz 2022-7-1
编辑：Adam Danz 2023-3-17
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)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by