Thread Subject: xlsread

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?

"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

"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