structure to xls file
1 view (last 30 days)
Show older comments
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?
0 Comments
Accepted Answer
Jan
on 21 Nov 2011
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.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!