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

Question

raghavendra kandukuri 2018-9-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/417927-i-am-new-to-matlab-and-i-have-this-question-regarding-execel

编辑： madhan ravi 2018-9-7

exp2.xlsx

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

madhan ravi 2018-9-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/417927-i-am-new-to-matlab-and-i-have-this-question-regarding-execel#answer_335778

编辑：madhan ravi 2018-9-6

在 MATLAB Online 中打开

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 2018-9-6

is everything clear?

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.

请先登录，再进行评论。