MATLAB: Structure to xls file

fopenstructures

Hi I want to convert structure to xls file. I have a structure like:
my_stat=struct('Models',{{'KS','FK'}},'Mean',{[mean(KS),mean(FK)]})
I want to write this structure in an excel file. I come up with this one:
fid = fopen('my_results.xls','W');
fprintf(fid, '%f\n', my_stat);
fclose(fid);
type my_results.xls
But my program gives me error message
??? Error using ==> sprintf
Function is not defined for 'struct' inputs.
How shall I proceed?

Best Answer

fid = fopen('my_results.xls', 'w');
fprintf(fid, '%s\t', my_stat.Models{:});
fprintf(fid, '\n');
fprintf(fid, '%f\t%f\t', my_stat.Mean);
fprintf(fid, '\n');
fclose(fid);
type my_results.xls
if mean(KS) and mean(FK) are not scalars, the format string must be adjusted.
Related Question