Info

此问题已关闭。请重新打开它进行编辑或回答。

Simple question how do I adjust the for loop to go through the rows of the excel matrix one by one. Milesdriven adds the columns 2:11 of the first row, i want the calculation to be done for the next 54 rows as well.

1 次查看（过去 30 天）

显示更早的评论

Khalid Tewfik 2016-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/315357-simple-question-how-do-i-adjust-the-for-loop-to-go-through-the-rows-of-the-excel-matrix-one-by-one

关闭： MATLAB Answer Bot 2021-8-20

在 MATLAB Online 中打开

 filename = 'project3data.xlsx';
 num = xlsread('project3data.xlsx');
 for i = 1:55
       milesdriven = sum(num(2,2:11))
 end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2016-12-5

Duplicates http://www.mathworks.com/matlabcentral/answers/315288-how-do-i-get-i-to-loop-through-the-55-columns-of-the-excel-file-one-by-one-i-want-i-to-correspond-t which is waiting for a response.

Please do not continue to discuss here.

此问题已关闭。

回答（1 个）

Tamir Suliman 2016-12-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/315357-simple-question-how-do-i-adjust-the-for-loop-to-go-through-the-rows-of-the-excel-matrix-one-by-one#answer_245950

在 MATLAB Online 中打开

 filename = 'project3data.xlsx';
 num = xlsread('project3data.xlsx');
 for i = 1:55
for j =2:11
       milesdriven = sum(num(i,j))
end
 end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2016-12-5

That will not work, that overwrites the answer each time.

此问题已关闭。

标签

Community Treasure Hunt

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

Translated by