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
回答(3 个)
Example:
filename='hello.xls' #Name of file
x=xlsread(filename, 'B2')
Lotus Kannan
2017-3-14
0 个投票
%% x only reads B column values from the excel
filename='example.xlsx';
x = xlsread(filename,'B:B');
Shirin Mozaffari
2018-7-18
0 个投票
for example you wanna read cell A2. This is what you should do: cell = xlsread(fileName,'A2:A2')
2 个评论
Jesus Leal
2022-3-13
what if i wanted to recall a cell and every 6th cell after that
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")
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!