MATLAB Central Newsreader - xlsread-multiple sheets

xlsread-multiple sheets

enviro — Tue, 20 Oct 2009 08:58:52 -0400

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

Re: xlsread-multiple sheets

Giacomo Faggiani — Tue, 20 Oct 2009 12:03:06 -0400

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

matrix = xlsread('test', Sheet);

try without marks

Giacomo

Re: xlsread-multiple sheets

enviro — Tue, 20 Oct 2009 12:32:43 -0400

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.

Re: xlsread-multiple sheets

Leslie McBrayer — Tue, 20 Oct 2009 13:37:17 -0400

"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

Re: xlsread-multiple sheets

enviro — Wed, 21 Oct 2009 09:39:23 -0400

Thanks for the help

Re: xlsread-multiple sheets

ujjwal saha — Sun, 08 Nov 2009 12:31:02 -0500

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

Re: xlsread-multiple sheets

enviro — Tue, 10 Nov 2009 07:20:01 -0500

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