How would automatically import excelfiles into MATLAB?

Hi, guys. I want to automatically import excelfiles into MATLAB. I use this code.

--------------------------------------------

source_dir = 'C:/Users/Cju/Documents/MATLAB/a' ;
source_files = dir(fullfile(source_dir, '*.xlsx'));
for i = 1:length(source_files) ;
   data(i) = xlsread(fullfile(source_dir, source_files(i).name));
end
--------------------------------------------

But just import final file. What is wrong?

Answer 1

[Image Analyst]

Chances are that won't work unless your workbooks have only a single scalar value in them. You would need data to be a cell array

data{i} = xlsread(.......

Please read the FAQ: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F

[JIN-HWA JEONG]

Thank guys. Even last, I'm sorry I did not get the help you gave me an answer.

SO, data{i} is organized 1x5 cell. good!!

But I want the average value of each cell.

Each cell is organized about 1500x7 matrix.

[JIN-HWA JEONG]

Where I put the fuction related average ?

[Image Analyst]

Just put this in the loop after you read in data{i}:

for k = 1 : length(data{i})
   theMean(i, k) = mean(data{i});
end