how do I get i to loop through the 55 columns of the excel file one by one. I want i to correspond to the values of the 55 columns to calculate miles driven
1 回表示 (過去 30 日間)
古いコメントを表示
filename = 'project3data.xlsx';
num = xlsread('project3data.xlsx');
for i = 1:55
milesdriven = sum(num(2,2:11))
end
0 件のコメント
回答 (1 件)
Walter Roberson
2016 年 12 月 4 日
Guessing that you only want rows 2 to 11:
milesdriven(i) = sum(num(2:11, i))
4 件のコメント
Walter Roberson
2016 年 12 月 4 日
With no loop:
%adjust these four lines according to your needs
first_row_with_data = 2;
last_row_with_data = size(num, 1);
first_column_with_data = 2;
last_column_with_data = size(num, 2) - 1;
milesdriven = sum( num(first_row_with_data : last_row_with_data, first_column_with_data, last_column_with_data), 2) );
This will sum for each row.
This assumes that your file matches http://www.mathworks.com/matlabcentral/answers/314481-solving-a-for-loop-problem-with-imported-data
参考
カテゴリ
Help Center および File Exchange で Loops and Conditional Statements についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!