Save data in excel
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Jadiel Silva
le 15 Déc 2013
Commenté : Azzi Abdelmalek
le 17 Déc 2013
Hello I am new to matlab and would like your help. I have a program that reads the file. Mat. When I read that file to transform vector data matrix and so I need to save it in excel. But I have 50 files. Mat and need to save all vectors one after another in excel so they become a single vector in excel. I greatly appreciate any help.
8 commentaires
Image Analyst
le 16 Déc 2013
Can Excel handle 12.5 million rows? If it can, I agree with Azzi, just concatenate them all in MATLAB, then call xlswrite() just once with the 12.5 million element vector.
Azzi Abdelmalek
le 16 Déc 2013
Modifié(e) : Azzi Abdelmalek
le 16 Déc 2013
I don't think Excell can handle 12.5 millions rows.It's better to save each matrix in different sheet
Réponse acceptée
Azzi Abdelmalek
le 15 Déc 2013
Modifié(e) : Azzi Abdelmalek
le 16 Déc 2013
I don't know, why you want to save them all as one vector instead a matrix 2500x500. But if you want to save your data as a vector, load your data in your files, concatenate them in one vector v then write
xlswrite('file.xlsx',v)
To load your files, put all your 50 files in one folder, for example D:\yourfolder. If your array is named M in your files:
folder='D:\yourfolder'
d=dir('*.mat')
for k=1:numel(d)
data=lod(d(k).name);
M=data.M;
v=[v;M(:)];
end
xlswrite('file.xlsx',v)
5 commentaires
Azzi Abdelmalek
le 17 Déc 2013
v should be initialized
folder='D:\vetor'
d=dir('*.mat')
v=[];
for k=1:numel(d)
data=lod(d(k).name);
APDI=data.APDI;
v=[v;APDI(:)];
end
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!