calculate average column in multiple files

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)

Answer 1

[madhan ravi]

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

[viet le]

thanks. but I was wondering how to import just one column