Save data in excel
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Jadiel Silva
il 15 Dic 2013
Commentato: Azzi Abdelmalek
il 17 Dic 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 Commenti
Image Analyst
il 16 Dic 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
il 16 Dic 2013
Modificato: Azzi Abdelmalek
il 16 Dic 2013
I don't think Excell can handle 12.5 millions rows.It's better to save each matrix in different sheet
Risposta accettata
Azzi Abdelmalek
il 15 Dic 2013
Modificato: Azzi Abdelmalek
il 16 Dic 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 Commenti
Azzi Abdelmalek
il 17 Dic 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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!