Export to Excel results from a function with a nested array

2 次查看（过去 30 天）

显示更早的评论

Diego 2012-12-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55761-export-to-excel-results-from-a-function-with-a-nested-array

在 MATLAB Online 中打开

Dear all,

I'm exporting to excel the results of a function that contain some statistics.

2 of the results are themselves arrays.

This suppose a problem, since those results are not exported to my excel file.

This is the cell array to be exported:

'mean'  1.78016727419355
'sem'  0.0934817511799512
'numel'  186
'gname'  '1'
'std'  1.27492110794460
'var'  1.62542383148268
'min'  0
'max'  4.71372000000000
'range'  4.71372000000000
'meanci'  [1.59573993677146,1.96459461161564]
'predci'  [-0.741838634100196,4.30217318248729]

And this is what is actually exported:

mean  1.780167274
sem  0.093481751
numel  186
gname  1
std  1.274921108
var  1.625423831
min  0
max  4.71372
range  4.71372
meanci  
predci

This is the function I'm using for these purposes:

function [Y]=descriptiveStats( X )
M={};
N=[];
M={'mean','sem','numel','gname','std','var','min','max','range','meanci','predci'}.';
[mean,sem,numel,gname,std,var,min,max,range,meanci,predci]=grpstats(X,[],{'mean','sem','numel','gname','std','var','min','max','range','meanci','predci'});
N=[mean,sem,numel,gname,std,var,min,max,range,meanci,predci].';
Y=[M,N];
xlswrite('df.xlsx',Y)
end