convert a .mat to excel file

107 次查看（过去 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 个评论
显示 2更早的评论
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')

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by