Opening many excel files into different matrices

Hello all,

I have a large amount of excel files containing many rows and columns (different each time). I would like to load each file as a matrix with an ascending index in MATLAB. Till now, the only thing I have figured out is to create a big zero 3D matrix and filling it up.

The unfortunate event with this method is that I end up with many zeros that I don't want as all the z-direction matrices need to be of the same size.

Any idea?

Thanks a lot in advance!

[Pierre Benoit]

Have you try using cell arrays ?

Answer 1

[Iain]

A cell array would be ideal. Example:

 list = {'file1.xls','C:\data\file2.xls', ....};
 for i = 1:numel(list)
  data{i} = xlsread(list{i});
  plot(data{i}(:,1),data{i}(:,1)); hold all
 end