Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: xlswrite to Excel 2007 problem
Date: Thu, 4 Sep 2008 19:11:02 +0000 (UTC)
Organization: Sandia National Labs
Lines: 18
Message-ID: <g9pbs6$5fr$1@fred.mathworks.com>
References: <g9p4li$7qd$1@fred.mathworks.com> <8625406.1220553764085.JavaMail.jakarta@nitrogen.mathforum.org>
Reply-To: <HIDDEN>
NNTP-Posting-Host: webapp-05-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1220555462 5627 172.30.248.35 (4 Sep 2008 19:11:02 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Thu, 4 Sep 2008 19:11:02 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 1316302
Xref: news.mathworks.com comp.soft-sys.matlab:488654



> Hi,
> xlwrite do not support customize format. So although you 
give the file extension as '.xls'. IT will still use 2007 
format.
> One way without modify xlswrite is, run these lines first:
> Excel = actxserver('excel.application');
> set(Excel, 'DefaultSaveFormat', 'xlExcel9795') ;
> Excel.Quit ;
> Otherwise you have to modify the xlswrite.
> Regards.


Thanks Bill. I've tried this and get the following error:
???Error: Object returned error code: 0x800A03EC

that looks like some kind of Excel limitation. Even using 
the inspector window in MATLAB, if I try changing to 
xlExcel9795, the change won't take effect.