Reading specific Cell in Excel

256 views (last 30 days)
Russell
Russell on 30 May 2014
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

Answers (3)

Mahdi
Mahdi on 30 May 2014
Edited: Mahdi on 30 May 2014
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')

Lotus Kannan
Lotus Kannan on 14 Mar 2017
%% x only reads B column values from the excel
filename='example.xlsx';
x = xlsread(filename,'B:B');

Shirin Mozaffari
Shirin Mozaffari on 18 Jul 2018
for example you wanna read cell A2. This is what you should do: cell = xlsread(fileName,'A2:A2')
  2 Comments
NAFTALI HERSCOVICI
NAFTALI HERSCOVICI on 29 May 2022
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")

Sign in to comment.

Products

Community Treasure Hunt

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

Start Hunting!

Translated by