convert mat file to excel
38 次查看(过去 30 天)
显示 更早的评论
how can i convert a mat file into an excel file
0 个评论
采纳的回答
Walter Roberson
2024-8-9,23:01
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 个评论
Walter Roberson
2024-8-10,18:13
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.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!