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

2 次查看（过去 30 天）

Leon 2019-6-4

评论： Star Strider 2019-6-4

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 2019-6-4

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')

Leon 2019-6-4

Many thanks! It works.

Star Strider 2019-6-4

As always, my pleasure!

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

R2019a

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

Translated by