MATLAB Central Newsreader - xlsread

xlsread

Alasdair — Fri, 17 Aug 2007 16:52:13 -0400

When using xlsread I am only able to read one sheet of
Excel data into Matlab. I can not read another sheet in
later in the session. Any one know a way round this?

Re: xlsread

josep — Fri, 17 Aug 2007 19:07:49 -0400

"Alasdair " <alasdair.macarthur@ed.ac.uk> wrote in message
<fa4jnt$jc$1@fred.mathworks.com>...
> When using xlsread I am only able to read one sheet of
> Excel data into Matlab. I can not read another sheet in
> later in the session. Any one know a way round this?

Hi,

Try...
>>xlsread(file,'sheet2')

or use the name of the sheet

Re: xlsread

Yair Altman — Sat, 18 Aug 2007 18:02:05 -0400

"josep " <joancampoy@hotmail.com> wrote in message

>>xlsread(file,'sheet2')

This works, but is painfully slow if you have several
worksheets you wish to read one after the other. The reason
is that xlsread opens and closes an Excel COM server each
time, and does not reuse an open server connection. There
are a couple of solutions for that on the Matlab File
Exchange - one of them is my OfficeDoc -
http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=15192

Yair Altman
http://ymasoftware.com