how to read multiple sheets of excel file using readtablle command. The way we do using xlsread(fi​leName,'sh​eet1')

18 次查看(过去 30 天)
This is what I am trying to do using readtable instead of xlsread
[data,text] = xlsread(file,'Definitions'); a = readtable(file, 'Definitions')
Catchup this error
All parameters must have an associated value.

采纳的回答

Voss
Voss 2022-6-9
% a = readtable(file, 'Definitions') % not this
a = readtable(file, 'Sheet', 'Definitions') % this
  4 个评论
Aakriti Srivastava
Hey Voss,
One more doubt the sheet named Definitions have numerical and text file and If I want to retrive element at 2nd row and 3rd coloumn. Would you tell me how to do that?

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by