I am new to MATLAB and i have this question regarding execel

1 次查看（过去 30 天）
raghavendra kandukuri
编辑： madhan ravi 2018-9-7
I have an excel, out of all columns, i want to do some math on column 3, where it should visit all the cells in column 3 and check if it is equal to zero, if it is then perform some calculation else perform this. for example:
if(DesiredFuel == 0) % DesiredFuel is the name of column 3
{
%
%
}
else
{
}
% Please find the excel attached

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

采纳的回答

madhan ravi
madhan ravi 2018-9-6
编辑：madhan ravi 2018-9-6
Try this:
[num,txt,raw]=xlsread('exp2.xlsx')
DESIRED_FUEL = num(:,3)
for i = 1:numel(DESIRED_FUEL)
if DESIRED_FUEL(i)==0
%your calculation
else
end
end
  2 个评论
madhan ravi
madhan ravi 2018-9-7
编辑：madhan ravi 2018-9-7
@Raghavendra haven’t heard from you in a while if my answer is what you were looking then please accept my answer if not let know what’s more required.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by