structure to xls file

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?

Answer 1

[Jan]

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.

[Meh]

Perfect!!!!!!!!!! Thanks Jan!!! Only the excel file does not open afterwards. even if i try it manualy!

[Meh]

Problem Solved!. I forgot to delete previous excel file and run again. Now fine.