Info
Questa domanda è chiusa. Riaprila per modificarla o per rispondere.
can anybody help me with matlab coding+excel??
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
I have got many files lets say 30 files ,in each file there are 3 columns of data but the no: of rows varies for each file .for eg 1 file has got 6 rows and 3 columns then next file has 3 rows and 3 columns etc .i was not able to append it since its size varies.i need 2 write all these data in an excel sheet also . pls help me??
0 Commenti
Risposte (2)
David Sanchez
il 29 Mag 2013
N_files = 30;
for k = 1:N_files
file_name = strcat('name',num2str(k));
file_name = strcat(file_name,'.xls');
data{k} = readxls(file_name);
end
You will end up with a cell array, whose cells content may be of different size. Later, you can handle this data as you please, even write it all to a single xls file
1 Commento
Image Analyst
il 29 Mag 2013
Can you use csvread() or dlmread() plus the FAQ to read each file into a matrix? Append all the individual matrices together into one big matrix. You can append them vertically as long as they all have 3 columns.
allData = [];
for k = 1 : number of files
% Make sure you change filename at each iteration.
fullFilename = fullfile(folder, files{k}.name);
dataFromOneFile = csvread(fullFilename );
allData = [allData; dataFromOneFile];
end
Then send that matrix out to Excel using xlswrite().
0 Commenti
Questa domanda è chiusa.
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!