MATLAB: How to export variables in mat file to excel

export data

I have a lot of data to deal with. I have saved different variables in a structure data. for example:
HistStruct:
         velocity < 12441x1 double >
         median   0.1449
         mean     0.1552
and I save them into mat file. I have nearly 100 HistStruct.mat files. Now I want to calculate the average value of each of them. But I dont know how to export them from variables edit. Can anyone help me? Thank you very much.

Best Answer

How about if you attach histstruct.mat? Basically you don't import a mat file to Excel. It's more of a two or three step process. You load it into MATLAB first, and then export it from MATLAB to Excel with xlswrite().
To load it into MATLAB first, you have to read in all your mat files and build up a big cell array to contain all the data. The FAQ will be helpful for that: http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F
Then you write the cell array to Excel in a single call to xlswrite() after your loop exits.
Related Question