Path: news.mathworks.com!newsfeed-00.mathworks.com!newsfeed2.dallas1.level3.net!news.level3.com!postnews.google.com!i24g2000prf.googlegroups.com!not-for-mail
From: otto <jared.otto@gmail.com>
Newsgroups: comp.soft-sys.matlab
Subject: Re: xlswrite to Excel 2007 problem
Date: Thu, 4 Sep 2008 11:29:19 -0700 (PDT)
Organization: http://groups.google.com
Lines: 46
Message-ID: <ce60b9f2-fd35-456c-b914-a4a140eb5ca0@i24g2000prf.googlegroups.com>
References: <g9p4li$7qd$1@fred.mathworks.com>
NNTP-Posting-Host: 67.221.64.52
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1220552959 10937 127.0.0.1 (4 Sep 2008 18:29:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 4 Sep 2008 18:29:19 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: i24g2000prf.googlegroups.com; posting-host=67.221.64.52; 
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_4; en-us) 
Xref: news.mathworks.com comp.soft-sys.matlab:488638



Go back to Excel 2003!  I've been resisting the upgrade for years.

Not sure right now - I haven't used xlswrite in a number of years, but
always remember that it was finicky when I did.  Sometimes when
Outlook checked email it would break the connection between Matlab and
Excel.  I think your problem is due to the way Matlab interfaces with
Excel in xlswrite.m in that it starts a COM connection with whatever
version of Excel that's on your machine and generates the output file
by sending commands to Excel through the COM interface.  So even
though you don't directly see the XLS file you're generating it with
your incompatible version of Excel.

I would suggest looking into the compatibility options in your version
of Excel (probably really deep in there) to see if there's a way to
always save in a backwards compatible format or run extra checks
everytime it saves a file.  If that fails you you can always write the
data to a CSV file for quick sharing if people don't have a lot of
hangups with format...  The CSV will open with the least complications
in any version of Excel.

Cheers,
Otto


On Sep 4, 1:08=A0pm, "Michael Lenz" <mcl...@sandia.gov> wrote:
> Hello All -
>
> I've got a function that utilizes xlswrite to spit out some
> summary data to xls sheets for quick review; a function
> that I've been using for several months. =A0Recently, I
> installed Office 2007 and am now running into problems with
> people running Excel 2003 not being able to open the xls
> files I've written.
>
> I've made no changes to the function since I last used
> Excel 2003 and the output files are being saved with
> the .xls extension. The files open fine with Excel 2007,
> but when I try with Excel 2003 I get a warning message that
> says the file is in an unrecognizable format. =A0When I
> proceed to open the file, it is a mess of miscellaneous
> characters.
>
> Any ideas or suggestions?
>
> Thanks!