creating array of fix and changing variables for xlswrite export

1 view (last 30 days)
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 Comments
adi kul
adi kul on 21 Jun 2017
X1,X2 changes over loop. And results of X3,X4,X5 are also changes as per X1 and X2.
All X1,X2,X3,X4,X5 are single numeric values.
I tried this:
data(ii,:)=[X1(ii),X2(ii),X3,X4,X5];
Still this error:
Subscripted assignment dimension mismatch.
alice
alice on 21 Jun 2017
Edited: alice on 21 Jun 2017
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)

Sign in to comment.

Answers (1)

dpb
dpb on 21 Jun 2017
Edited: dpb on 22 Jun 2017
>> [{' '} 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.

Tags

Community Treasure Hunt

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

Start Hunting!