Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: xlsread
Date: Sat, 18 Aug 2007 18:02:05 +0000 (UTC)
Organization: TACT Computer Systems Ltd
Lines: 14
Message-ID: <fa7c6t$5ba$1@fred.mathworks.com>
References: <fa4jnt$jc$1@fred.mathworks.com> <fa4rm5$81d$1@fred.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-02-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1187460125 5482 172.30.248.37 (18 Aug 2007 18:02:05 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Sat, 18 Aug 2007 18:02:05 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 642467
Xref: news.mathworks.com comp.soft-sys.matlab:424414



"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