How to read specific sheet from an excel file using readcell?

I am unable to find the command which can read specific sheet from an excel file using readcell since is not recommending to use xlsread and xlswrite

[Mathieu NOE]

hello

what have you tried so far ? have you tried with readtable ?

[Akshay Chandel]

What I mean is xlsread has the command to read data of a specific sheet in xlsx file. Now matlab is recommending to use readmatrix, readtable or readcell to read xlsx file. Do we have that reading specific sheet feature in any of the three commands MATLAB is recommending.

In simple words I want to read data only from constant sheet but the three commands "readmatrix, readtable and readcell" are only reading first sheet that is signal here.

Answer 1

[Simon Chan]

Try the following for an excel file name 'demo.xlsx', and sheet name 'Signals'.

It is the same for readtable or readmatrix.

readcell('demo.xlsx','UseExcel',true,'Sheet','Signals')

[Mathieu NOE]

well

FYI

you can also use readtable with "Sheet" as parameter

read the doc

[Akshay Chandel]

Thank you Simon. Its working. How did you know this. I read the whole document but coudnt find it.

[Simon Chan]

It is in the documentation.