Thread Subject: xlsread-multiple sheets

Hi there;

I would like to read multiple excel sheets and save each sheet as separate matrix. I have tried below but there is a problem yet. Any help would be appreciated.
 
%--------------------------
[type,sheetname] = xlsfinfo('test.xls');
m=size(sheetname,2);

for(i=1:1:m);
Sheet = char(sheetname(1,i)) ;
matrix = xlsread('test', 'Sheet');
end

> matrix = xlsread('test', 'Sheet');

matrix = xlsread('test', Sheet);

try without marks

Giacomo

Thanks for your reply.
It now gives only final sheet. I wonder if I could have all sheets and a way to save them into individual matrices.

"enviro" <farhadnejadkoorki@yahoo.co.uk> wrote in message
news:1789462907.86588.1256041993772.JavaMail.root@gallium.mathforum.org...
> Thanks for your reply.
> It now gives only final sheet. I wonder if I could have all sheets and a
> way to save them into individual matrices.

You could create a cell array as follows:

alldata = cell(1, m);

for(i=1:1:m);
Sheet = char(sheetname(1,i)) ;
alldata{i} = xlsread('test', Sheet);
end

Thanks for the help

thanks a lot...it saved lots of my energy...

Is it posible to read rawdata of each sheet as well?
[N, T, rawdata] = xlsread('filename', ...)