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

1 vue (au cours des 30 derniers jours)
raghavendra kandukuri
raghavendra kandukuri le 6 Sep 2018
Modifié(e) : madhan ravi le 7 Sep 2018
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

Réponse acceptée

madhan ravi
madhan ravi le 6 Sep 2018
Modifié(e) : madhan ravi le 6 Sep 2018
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 commentaires
madhan ravi
madhan ravi le 6 Sep 2018
is everything clear?
madhan ravi
madhan ravi le 7 Sep 2018
Modifié(e) : madhan ravi le 7 Sep 2018
@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.

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by