MATLAB: Calculate average column in multiple files

multiplexlsreadxlswrite

I have 10 .xls files (name file1.xls, file2.xls…) in a folder, each has 10 columns (Ai, Bi, Ci,…). Now I want to create one .xls file that calculate average of column A, B, C… (A=A1+A2+…+A10/10); (B=B1+B2+…+B10)……

A1, A2, A3 … A10 have various length as well as Bi, Ci, Di……

example (attached)

Best Answer

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

Related Solutions

MATLAB: How to compare two .xls files

Load the .xls files into matlab using xlsread. Pick the column you want and use ismember. Read about xlsread and ismemebr.

MATLAB: Importing Data from Excel

d=dir('*.xlsx');  % return directory list of all Excel files
x=[];
for i=1:length(d)
  x=[x;xlsread(d(i).name,'B:B');
end

Best Answer

Related Solutions

MATLAB: How to compare two .xls files

MATLAB: Importing Data from Excel

Related Question