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

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.

Answer 1

[Voss]

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

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

[Aakriti Srivastava]

Thanks alot.It worked

[Voss]

You're welcome!

[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?

[Voss]

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

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