Summing numerical data of excel files in Matlab
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Lucky
el 4 de Oct. de 2013
Comentada: Ali Hijazi
el 1 de Mzo. de 2022
Hi to all matlab geniuses! I am new in matlab, hope somebody can help me. The question is following: I have 100 excel files with numerical data. I need to sum up relative columns of each file, thus creating a new excel file. Example: My 1st excel file content:
name1 10
name2 20
name3 30
name4 40
name5 50
Second excel file content:
name1 50
name2 40
name3 30
name4 20
name5 10
and other 98 are the same format..
So, I need final excel file like this:
name1 60
name2 60
name3 60
name4 60
name5 60
How to make it in Matlab??? Thank you very much in advance!!
0 comentarios
Respuesta aceptada
Cedric
el 4 de Oct. de 2013
Editada: Cedric
el 4 de Oct. de 2013
Assuming file names to be coded as follows: data_001.xlsx, data_002.xlsx, .., data_100.xlsx, you could build a solution based on the following approach
nFiles = 100 ;
for fId = 1 : nFiles
filename = sprintf( 'data_%03d.xlsx', fId ) ;
num = xlsread( filename ) ;
if fId == 1
buffer = num ; % See note 1.
else
buffer = buffer + num ; % See note 1.
end
end
Note 1: this assumes that there is only one column of numeric values in the file. If there are multiple, you have to select the relevant column, e.g. if it's column 3: buffer=num(:,3) and buffer=buffer+num(:,3).
This approach can be extended a little with code for e.g. taking all files from a specific folder, or matching names if they can be stored in various orders.
2 comentarios
Más respuestas (1)
Ronnel Jay
el 31 de Jul. de 2014
help pls. how about if i have this kind of file in which contains random arrangements of names and i want to summarizing or addition of same name?
name1 50 name2 40 name3 30 name4 20 name5 10 name1 50 name2 40 name3 30 name4 20 name5 10 name1 50 name2 40 name3 30 name4 20 name5 10
2 comentarios
Ali Hijazi
el 1 de Mzo. de 2022
Hello,
did you solve this ?
I have multiple files with different names for example : TF_a1_E1z_R1z.dat and TF_a1_E1x_R1y.dat
TF_a3_E8z_R15z.dat etc etc... how can it be resolved ? since i want to sum the second column of these numeric data
Thanks
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!