Reading specific Cell in Excel

I am trying to read a certain cell in Excel with matlab.(B2)

I am then going to use this in an if statement.

Please advise

Answer 1

[Mahdi]

Have you looked at the xlsread documentation? It tells you exactly how to do it.

Example:

filename='hello.xls' #Name of file
x=xlsread(filename, 'B2')

Answer 2

[Lotus Kannan]

%% x only reads B column values from the excel

filename='example.xlsx';

x = xlsread(filename,'B:B');

[Gamal Zayed]

Thanks

Answer 3

[Shirin Mozaffari]

for example you wanna read cell A2. This is what you should do: cell = xlsread(fileName,'A2:A2')

[Jesus Leal]

what if i wanted to recall a cell and every 6th cell after that

[NAFTALI HERSCOVICI]

Is there any way to use the cell indices rather than letters to specify columns?

Like in excel the range can be defined as Range(cells(2,1),cells(2,1)) instead of Range("a2:a2")