MATLAB Answers

creating array of fix and changing variables for xlswrite export

1 ビュー (過去 30 日間)
adi kul
adi kul 2017 年 6 月 21 日
編集済み: dpb 2017 年 6 月 22 日
I have created 2 commands:
col_header={'Col1','Col2','Col3','Col4','Col5'};
data{ii}=[X1,X2,X3,X4,X5];
data_cells{ii}=num2cell(data{ii});
The variables X1,X2,X3,X4,X5 changes over the loop and I want to export each loop values for the same.
My main intent is to get a output file of excel spreadsheet with 5 columns named as:
col_header={'Col1','Col2','Col3','Col4','Col5'};
and the values of X1,X2,X3,X4,X5 will be pasted over the loop below the above titles respectively.
I tried this:
output_matrix=[{' '} col_header; data_cells];
But getting error of dimensions.
Dimensions of matrices being concatenated are not consistent.
Please help me.
  7 件のコメント
alice
alice 2017 年 6 月 21 日
Can you tell what Matlab returns when you ask for the sizes of all items after you get the error (using the size function) please ? It would help understand.
nd = size(data(ii,:))
n1 = size(X1)
n2 = size(X2)
...
n5 = size(X5)

サインインしてコメントする。

回答 (1 件)

dpb
dpb 2017 年 6 月 21 日
編集済み: dpb 2017 年 6 月 22 日
>> [{' '} col_header]
ans =
' ' 'Col1' 'Col2' 'Col3' 'Col4' 'Col5'
>>
You've added a blank column to the first row that isn't in the second; hence you can't (vertically) concatenate the two. Just lose the blank entry and set the target row/column in the spreadsheet to 'B1' instead of 'A1' if that's the intent.
However, you don't really need to do the concatenation, write
output_matrix={'Col1','Col2','Col3','Col4','Col5'};
...
for ii=iLo:iHi % begin the loop
....
% compute the values here
...
output_matrix{ii+1}=num2cell([X1,X2,X3,X4,X5]);
...
end
Stylistic Comment: In general, having sequentially-named variables such as your X n above is indicative that haven't used the power of Matlab as fully as could have done. An array X may be much easier to code and maintain code for instead. We haven't seen the rest of the code that generated these names so can't give specifics, but it's worth looking at ways to vectorize the code and remove such repetition.

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by