convert mat file to excel
9 views (last 30 days)
Show older comments
how can i convert a mat file into an excel file
0 Comments
Accepted Answer
Walter Roberson
on 9 Aug 2024
You cannot generally convert .mat file to excel.
You can potentially convert to excel under the special case that the .mat file contains exactly one variable, and the one variable is a scalar or vector or 2D numeric, or the one variable is a 2D cell array (each entry of which is empty or scalar numeric or character vector or scalar string), or the one variable is a struct array in which each field of the array is empty or scalar numeric or character vector or scalar string, or the variable is a table() object.
If the .mat file contains a single variable that is scalar or vector or 2D numeric, then extract the variable from the .mat file and writearray()
If the .mat file contains a single variable that is a 2D cell array, then extract the variable from the .mat file and writecell()
If the .mat file contains a single variable that is a table() object, then extract the variable from the .mat file and writetable()
If the .mat file contains a single variable that is a struct array, then extract the variable from the .mat file and struct2table() and writetable()
If the .mat file contains more than one variable, then the best you can do is somehow group all of the variables together and write out the result -- or to write out the individual variables as different sheets in the excel file.
4 Comments
Walter Roberson
on 10 Aug 2024
I could write out code that extracted variables one-by-one from the .mat file, and then examined the variable to determine how best to convert it to an excel sheet. But frankly, doing that would be a waste of my time, because you already know exactly what your .mat looks like and so you can directly implement one of the described steps without going through all of the cross-checks that would be necessary for the general case.
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!