convert a .mat to excel file

91 次查看(过去 30 天)
mehra
mehra 2024-4-2
回答: KSSV 2024-4-4
Hello, I have so many .mat files that I want to convert them to excel.
the first one (If I want to do one by one) name is A_Q1S1.mat.
What is the correct code for that?
  4 个评论
mehra
mehra 2024-4-2
My .mat data names are like :
A_Q1S1
A_Q1S2
A_Q1S3
A_Q2S1
A_Q2S2
A_Q2S3
A_Q3S1
A_Q3S2
A_Q3S3
the same is for B and C.
Should I do something more for the whole files?
Mathieu NOE
Mathieu NOE 2024-4-3
ok , we don't need any special approach for loading your different mat files
but what we miss here is :
  • what data you have stored in the mat files ,
  • which elements you want to export to excel
if you could share a couple of mat files ,that would be great

请先登录,再进行评论。

回答(1 个)

KSSV
KSSV 2024-4-4
matFiles = dir('*.mat') ;
N = length(matFiles) ;
T = table;
for i =1:N
load(matFiles(i).name) ;
T.(i) = val ; % I assume each mat file has a variable "val" which is single column of same size
end
writetable(T,'Test.xlsx')

Community Treasure Hunt

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

Start Hunting!

Translated by