From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: xlsread error (mac): "unexpected record length"
Date: Sat, 8 Aug 2009 22:14:02 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 21
Message-ID: <h5ktba$91h$>
References: <gfnk09$bbi$>
Reply-To: <HIDDEN>
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: 1249769642 9265 (8 Aug 2009 22:14:02 GMT)
NNTP-Posting-Date: Sat, 8 Aug 2009 22:14:02 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 982380
Xref: comp.soft-sys.matlab:561865

Did you find a solution to this? I've recently installed matlab & am getting exactly the same problem. Ican't seem to get an excel spreadsheet to load. It was fine on a colleague's PC.


"Eric " <> wrote in message <gfnk09$bbi$>...
> Hi there. 
> I recently just switched to a Mac and am encountering some new problems. xlsread is giving me the error:
> "File contains unexpected record length.  Try saving as Excel 98."
> The files are actually excel 97-04 so that shouldn't be the problem. I also have successfully read in some of the excel files. I have meteorological data from 20 sites and the spreadsheets are essentially identical but most of them give me this error. 
> I've tried re-saving the xls files, copying and pasting into a new file and copying a smaller portion of the file into a new file. None of the above worked and these were suggestions I got when searching other forums.
> I did notice that regardless of the files being identical (same fields and rows just different values) the file size varies greatly. I'm wondering if the files may be corrupt in some way? even though I can open them and everything seems to be there/ nothing missing. 
> Any help would be greatly appreciated 
> Thanks
> -eric