creating array of fix and changing variables for xlswrite export

2 次查看（过去 30 天）

adi kul 2017-6-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345658-creating-array-of-fix-and-changing-variables-for-xlswrite-export

编辑： dpb 2017-6-22

Hello All, I am in need of exporting my calculations to an excel spreadsheet. As shown in here: https://in.mathworks.com/matlabcentral/answers/101309-how-do-i-use-xlswrite-to-add-row-and-column-labels-to-my-matlab-matrix-when-i-write-it-to-excel-in-m

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 个评论
显示 5更早的评论隐藏 5更早的评论

adi kul 2017-6-21

在 MATLAB Online 中打开

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 2017-6-21

编辑：alice 2017-6-21

在 MATLAB Online 中打开

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 2017-6-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/345658-creating-array-of-fix-and-changing-variables-for-xlswrite-export#answer_271472

编辑：dpb 2017-6-22

在 MATLAB Online 中打开

>> [{' '} 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.