change variable and assign to dataset in each loop

Hello,

I have one excel file that contains 12 sheets. Each sheets contains 5 columns I want to read each sheet and put in one dataset. So, I am thinking is it possible for me to create for loop in order to have 12 datasets.

as an example:

for sheet=1:12;
%import excel file (sheet) 
% A(sheet)= dataset(column1, column2, column3, column4, column 5)
end

Answer 1

[Iain]

Three approaches

 for i = 1:12 %(Sheets not the same size)
  [numbers{i} texts{i} raws{i}] = xlsread(....);
 end

Or

 for i = 1:12   %(All sheets same size)
  numbers(:,:,i) = xlsread(...)
 end

Or

 numbers = [];
 for i = 1:12   %(All sheets same size)
  n = xlsread(...);
  numbers = [numbers; n];
 end

[Reyasudin]

ok..tq