# How to label columns in matrix?

조회 수: 25 (최근 30일)
Hannah 2021년 8월 18일
댓글: Hannah 2021년 8월 18일
How can I give the columns contaning values for m, o, r ,t and Diff_irr a label?
ResultMtx = [];
for m=1:length(months) %loop 12 times for the 12 months
for o=1:length(orientation) %loop 2 times for south and east
for r = 1:length(row) %loop 3 times for the 3 rows
for t=1:length(tilt) %loop 10 times for the 10 tilting possibilities, this also represents the rows in the matric of irr
%_____________calculations here to find Diff_irr_____________
ResultMtx = [ResultMtx;
m o r t Diff_irr];
end
ResultMtx = [ResultMtx;
nan nan nan nan nan];
end
end
end
xlswrite(strcat(Result_File), ResultMtx);
I attempted to write:
ResultMtx = [ResultMtx;
['month%d, orientation%d, rows%d, tilt%d Irradiance%d,', m, o, r, t, Diff_irr]];
but that did't work obviously and I got the error:
"Dimensions of arrays being concatenated are not consistent."
##### 댓글 수: 3이전 댓글 1개 표시이전 댓글 1개 숨기기
Hannah 2021년 8월 18일
Hi Marcel, I did that and at the end I wrote:
writetable(ResultTable, strcat(Result_File))
I got an error. Do you know what I'm doing wrong?
Simon Chan 2021년 8월 18일
편집: Simon Chan 2021년 8월 18일
Use the following code after calculating the 'Diff_irr':
temp = [m o r t Diff_irr];
ResultMtx = [ResultMtx; temp];

댓글을 달려면 로그인하십시오.

### 답변 (1개)

Chunru 2021년 8월 18일
% After the loop, you obtain ResultMtx. Convert it into a table with
% column names. Then write the table
ResultMtx = array2table(ResultMtx, 'VariableNames', ["Month","orientation", "rows", "tilt", "Irradiance"]);
writetable(T, 'res.xlsx');
##### 댓글 수: 3이전 댓글 1개 표시이전 댓글 1개 숨기기
Chunru 2021년 8월 18일
The following line should be outside of the loop:
ResultMtx = array2table(ResultMtx, 'VariableNames', ["Month","orientation", "rows", "tilt", "Irradiance"]);
Hannah 2021년 8월 18일
Now it's a lot closer to what I want (see image below).
But how can I have the column headers after every 10 lines, i.e. where I highlighted in yellow?

댓글을 달려면 로그인하십시오.

### 카테고리

Help CenterFile Exchange에서 Loops and Conditional Statements에 대해 자세히 알아보기

### Community Treasure Hunt

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

Start Hunting!

Translated by