Reading data from Microsoft Excel

What is the syntax for reading data from Microsoft Excel sheets? I tried the following and it returned error messages.

A = xlsread('amat.xlsx','sheet1','a1:a10')

I even changed the case of S in sheet to capital and the error persisted. Anyone with an idea?

[Cris LaPierre]

What is the full error message? Please share all the red text.

[Walter Roberson]

What shows up if you use

[status, sheets] = xlsinfo('amat.xlsx')

Answer 1

[Cris LaPierre]

Note that xlsread is not recommended. Assuming you are just importing a matrix of numbers, I would use readmatrix.

A = readmatrix('amat.xlsx','Sheet','sheet1','Range','a1:a10')

Answer 2

[Jatin]

Hi @Kelechi Nwosu,

There can be few reasons for getting errors while using the “xlsread” function.

Kindly follow these troubleshooting steps to make sure the function work correctly:

1. Make sure the file is in the current directory or provide the full path to the file.
2. Use the correct worksheet name and check for spelling and case sensitivity.
3. Ensure that the range is specified properly, incorrect range may throw errors.

From R2019a, “xlsread” is not recommended as stated in the official documentation. You can switch to using “readtable”, “readmatrix” and “readcell” instead.

You can refer to the following MathWorks documentations for more information:

https://www.mathworks.com/help/matlab/ref/xlsread.html

https://www.mathworks.com/help/matlab/ref/readmatrix.html

[Kelechi Nwosu]

Thanks a lot. I did all the suggested and still I was getting errors. I guess I shall have to switch to readmatrix as it is the function that gives the same set of results as xlsread.

[Cris LaPierre]

Consider attaching your file to your post using the paperclip icon. Please share the full error message (all the red text)