Reading specific Cell in Excel

87 Ansichten (letzte 30 Tage)
Russell
Russell am 30 Mai 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

Antworten (3)

Mahdi
Mahdi am 30 Mai 2014
Bearbeitet: Mahdi am 30 Mai 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 am 14 Mär. 2017
%% x only reads B column values from the excel
filename='example.xlsx';
x = xlsread(filename,'B:B');

Shirin Mozaffari
Shirin Mozaffari am 18 Jul. 2018
for example you wanna read cell A2. This is what you should do: cell = xlsread(fileName,'A2:A2')
  2 Kommentare
Jesus Leal
Jesus Leal am 13 Mär. 2022
what if i wanted to recall a cell and every 6th cell after that
NAFTALI HERSCOVICI
NAFTALI HERSCOVICI am 29 Mai 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")

Melden Sie sich an, um zu kommentieren.

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by