Subject: Re: xlswrite to Excel 2007 problem
From: Bill August <hui.song@beds.ac.uk>
Date: Thu, 04 Sep 2008 17:09:12 EDT
Message-ID: <3194495.1220562582966.JavaMail.jakarta@nitrogen.mathforum.org>
References: <g9p9j3$a8b$1@fred.mathworks.com>
Lines: 32
NNTP-Posting-Host: nitrogen.mathforum.org
Organization: The Math Forum
Path: news.mathworks.com!newsfeed-00.mathworks.com!nlpi057.nbdc.sbc.com!prodigy.net!news.glorb.com!transit3.readnews.com!news-xxxfer.readnews.com!news-out.readnews.com!transit4.readnews.com!news-out.usenet.com!prop.superfeed.net!news-in.newsfeeds.com!support1.mathforum.org!not-for-mail
Newsgroups: comp.soft-sys.matlab
X-Trace: support1-1.mathforum.org 1220562582 26652 144.118.30.135 (4 Sep 2008 21:09:42 GMT)
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: news@support1-1.mathforum.org
NNTP-Posting-Date: Thu, 4 Sep 2008 21:09:42 +0000 (UTC)
Xref: news.mathworks.com comp.soft-sys.matlab:488663



> A little more detail:
> 
> I think I can get around the problem if I can get
> xlswrite 
> to invoke Excel 2003 rather than 2007.  To do this I
> need 
> the programmatic identifier (progid) to feed to the
> command
> Excel = actxserver('Excel.Application').  The trouble
> is 
> that, from what I've uncovered is that both Excel
> 2003 and 
> 2007 use Excel.Application as their progid.  Does
> anyone 
> happen to know how I can change the progid of Excel
> 2003 to 
> see if that works?  Perhaps I can get 2003 to be
> invoked if 
> I knew what the interface name for Excel 2003 (from
> Office 
> 11) is.
> 
> Thanks.
> M Lenz
Hi
It is quite easy to solve.
Just some different between 03 and 07. 
Try this,
set(Excel, 'DefaultSaveFormat', 'xlExcel8') 
Regards.
Also you can set it in Excel 2007. It is in file->excel option->save option card.
Hope this can help.