Reading specific Cell in Excel

173 次查看（过去 30 天）
Russell
Russell 2014-5-30
评论： NAFTALI HERSCOVICI 2022-5-29
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

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

回答（3 个）

Mahdi
Mahdi 2014-5-30
编辑：Mahdi 2014-5-30
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 2017-3-14
%% x only reads B column values from the excel
filename='example.xlsx';
x = xlsread(filename,'B:B');
Shirin Mozaffari
Shirin Mozaffari 2018-7-18
for example you wanna read cell A2. This is what you should do: cell = xlsread(fileName,'A2:A2')
  2 个评论
Jesus Leal
Jesus Leal 2022-3-13
what if i wanted to recall a cell and every 6th cell after that
NAFTALI HERSCOVICI
NAFTALI HERSCOVICI 2022-5-29
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")

请先登录，再进行评论。

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by