MATLAB Answers

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

18 views (last 30 days)
Akshay Chandel
Akshay Chandel on 28 Sep 2021
Commented: Simon Chan on 28 Sep 2021
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
  2 Comments
Akshay Chandel
Akshay Chandel on 28 Sep 2021
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.

Sign in to comment.

Accepted Answer

Simon Chan
Simon Chan on 28 Sep 2021
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')
  3 Comments

Sign in to comment.

More Answers (0)

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by