convert mat file to excel

38 次查看(过去 30 天)
Alyaa
Alyaa 2024-8-9,22:36
评论: Alyaa 2024-8-13,8:26
how can i convert a mat file into an excel file

采纳的回答

Walter Roberson
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
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.
Alyaa
Alyaa 2024-8-13,8:26
Thank you very much I figured out where my mistake was

请先登录,再进行评论。

更多回答(0 个)

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by