清空筛选条件
清空筛选条件

Reading specific Cell in Excel

137 次查看（过去 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 中查找有关 Data Import from MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by