how to read multiple sheets of excel file using readtablle command. The way we do using xlsread(fileName,'sheet1')

20 次查看（过去 30 天）

显示更早的评论

Aakriti Srivastava 2022-6-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1737395-how-to-read-multiple-sheets-of-excel-file-using-readtablle-command-the-way-we-do-using-xlsread-file

编辑： Voss 2022-6-9

采纳的回答： Voss

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Voss 2022-6-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1737395-how-to-read-multiple-sheets-of-excel-file-using-readtablle-command-the-way-we-do-using-xlsread-file#answer_982505

在 MATLAB Online 中打开

% a = readtable(file, 'Definitions')            % not this
a = readtable(file, 'Sheet', 'Definitions')     % this

4 个评论
显示 2更早的评论隐藏 2更早的评论

Aakriti Srivastava 2022-6-9

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?

Voss 2022-6-9

编辑：Voss 2022-6-9

在 MATLAB Online 中打开

a = readtable(file, 'Sheet', 'Definitions', 'Range', 'C2:C2')

Reference: https://www.mathworks.com/help/matlab/ref/readtable.html#d123e1238578

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Numeric Types Logical

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

产品

MATLAB

版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by