Path: news.mathworks.com!not-for-mail
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$1@newscl01ah.mathworks.com>
References: <k6lkck$m5j$1@newscl01ah.mathworks.com> <k6p91o$k5b$1@newscl01ah.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: www-01-blr.mathworks.com
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: newscl01ah.mathworks.com 1351917914 10526 172.30.248.46 (3 Nov 2012 04:45:14 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Sat, 3 Nov 2012 04:45:14 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 2921053
Xref: news.mathworks.com comp.soft-sys.matlab:781924

Take a look at this for some ideas:
http://www.mathworks.com/help/matlab/ref/xlswrite.html

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" <barry.r.williamsnospam@saic.com> wrote in message <k6p91o$k5b$1@newscl01ah.mathworks.com>...
> "Inbanathan Govender" <govender.inbanathan@gmail.com> wrote in message <k6lkck$m5j$1@newscl01ah.mathworks.com>...
> > 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