From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: Exporting to Exel
Date: Sat, 3 Nov 2012 04:45:14 +0000 (UTC)
Organization: HSBC
Lines: 19
Message-ID: <k727gq$a8u$>
References: <k6lkck$m5j$> <k6p91o$k5b$>
Reply-To: <HIDDEN>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: 1351917914 10526 (3 Nov 2012 04:45:14 GMT)
NNTP-Posting-Date: Sat, 3 Nov 2012 04:45:14 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 2921053
Xref: comp.soft-sys.matlab:781924

Take a look at this for some ideas:

Just so you know, Excel does not really allow file sharing (you can't write to the file when someone else has it open on a network drive).  There are ways around it, but I don't think you want to go down that path, as it makes the file VERY unstable and susceptible to corruption. Just use a database if you really want multi-user control.

"Barry Williams" <> wrote in message <k6p91o$k5b$>...
> "Inbanathan Govender" <> wrote in message <k6lkck$m5j$>...
> > Hi,
> > 
> > I would like to write to an exel file, however when I try to do this with the exel file open, I get the following error: The file 'is not writable.  It may be
> > locked by another process'. How do I go around this without having to close the Exel file
> > 
> > Regards,
> > Inbanathan
> Are you using xlswrite? I don't know that it's possible to write to the file while it's open because the read only bit in the file is set while it's open in Excel.
> Barry