原创 XLSREAD error in Matlab

 2008-8-29 20:35  5621 6 6 分类: 工程师职场

Skipping 4 formatting runs.
XLS File contains unrecognized string header - skipping remaining text - (872:0xa 1086).
??? File does not contain valid Excel data. Invalid record ID.

Error in ==> C:\MATLAB6p5\toolbox\matlab\iofun\private\biffparse.dll
Error in ==> C:\MATLAB6p5\toolbox\matlab\iofun\xlsread.m
On line 94 ==> [n, s] = biffparse(biffvector, arg);

Error in ==> c:\temp\temp\Telcordia\data.m
On line 7 ==> sheet1=xlsread(file,sheets{1});
and
Skipping 4 formatting runs. ??? File contains unexpected record length. Try saving as Excel 98. Error in ==> C:\MATLAB6p5\toolbox\matlab\iofun\private\biffparse.dll Error in ==> C:\MATLAB6p5\toolbox\matlab\iofun\xlsread.m On line 94 ==> [n, s] = biffparse(biffvector, arg); Error in ==> c:\temp\temp\Telcordia\data.m On line 7 ==> sheet1=xlsread(file,sheets{1});

Solution:

This bug has been fixed for Release 14 (R14).

For previous releases, as a workaround, copy the contents of the sheet to a new file and then try using the XLSREAD command. Make sure that you copy the contents of the spreadsheet to a new file; do not simply perform a "Save As" on the file.

写原创有奖励！2024面包板原创奖励正在进行中