xlsread error: Array indices must be positive integers or logical values.

2019 6 4
2 个回答
回答已采纳
更新时间：2019 6 4
7 次查看（30 天）

0 个投票

When I try to use xlsread to read the attached Excel file:
[A B C] = xlsread('AA.xlsx');
Why do I keep getting this error? It seems the problem is the last column, but why?
Error using xlsread (line 257)
Array indices must be positive integers or logical values.
Many thanks!

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

 采纳的回答

Star Strider
Star Strider 2019-6-4

0 个投票

I was able to read your file without error.
However, if you have R2013b or lalter release, the readtable (link) function is likely the best option for your file:
AA_Table = readtable('AA.xlsx')

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Leon
Leon 2019-6-4
编辑：Leon 2019-6-4
Thanks for the suggestion of using readtable.
If I use [A B C] = xlsread('AA.xlsx'), my header info will be stored in B(1,:). Where will my header info stored, if I use T = readtable('AA.xlsx')?
I need to use the below command to query the headers to find the columns that I'm interested in:
isMatch = contains(B(1,:), 'abc', 'IgnoreCase',true)
Guillaume
Guillaume 2019-6-4
Definitively use readtable if your table has header. The header is converted into a variable name and not part of the data. If the rest of the data is numeric it is a lot more practical. To get the data matching the 'abc' header:
t = readtable(yourexcelfile);
t.abc
So much simpler!
Read the doc about tables.
Star Strider
Star Strider 2019-6-4
Try this:
AA_Table = readtable('AA.xlsx');
headers = AA_Table.Properties.VariableNames;
isMatch = contains(headers, 'abc', 'IgnoreCase',true);
When I tested that although using 'ph' as the match string, this worked correctly.
I am using Excel 2016 in Windows 10. I have no idea how Excel is implemented on a Mac.

请先登录，再进行评论。

更多回答（1 个）

Leon
Leon 2019-6-4

0 个投票

Thanks all for the replies. I'm using Excel Version 16.25 on MacOS 10.14.5

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2019a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by