Save data in excel
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Jadiel Silva
el 15 de Dic. de 2013
Comentada: Azzi Abdelmalek
el 17 de Dic. de 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 comentarios
Image Analyst
el 16 de Dic. de 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
el 16 de Dic. de 2013
Editada: Azzi Abdelmalek
el 16 de Dic. de 2013
I don't think Excell can handle 12.5 millions rows.It's better to save each matrix in different sheet
Respuesta aceptada
Azzi Abdelmalek
el 15 de Dic. de 2013
Editada: Azzi Abdelmalek
el 16 de Dic. de 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 comentarios
Azzi Abdelmalek
el 17 de Dic. de 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
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!