Save data in excel
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Jadiel Silva
am 15 Dez. 2013
Kommentiert: Azzi Abdelmalek
am 17 Dez. 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 Kommentare
Image Analyst
am 16 Dez. 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
am 16 Dez. 2013
Bearbeitet: Azzi Abdelmalek
am 16 Dez. 2013
I don't think Excell can handle 12.5 millions rows.It's better to save each matrix in different sheet
Akzeptierte Antwort
Azzi Abdelmalek
am 15 Dez. 2013
Bearbeitet: Azzi Abdelmalek
am 16 Dez. 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 Kommentare
Azzi Abdelmalek
am 17 Dez. 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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!