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

469 次查看（过去 30 天）
Akshay Chandel
Akshay Chandel 2021-9-28
评论： Simon Chan 2021-9-28
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 个评论
Akshay Chandel
Akshay Chandel 2021-9-28
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.

请先登录，再进行评论。

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

采纳的回答

Simon Chan
Simon Chan 2021-9-28
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 个评论
显示 1更早的评论
Akshay Chandel
Akshay Chandel 2021-9-28
Thank you Simon. Its working. How did you know this. I read the whole document but coudnt find it.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by