convert a .mat to excel file
72 views (last 30 days)
Show older comments
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 Comments
Mathieu NOE
on 3 Apr 2024
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
Answers (1)
KSSV
on 4 Apr 2024
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')
0 Comments
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!