Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

cannot read excel string data

Status
Not open for further replies.

olinn

Materials
Joined
Oct 26, 2005
Messages
21
Location
US
When I used xlsread to read a excel file containing both numerical and string data. I got a error in Matlab as follows:

Skipping 16 bytes of extended strings.
??? File does not contain valid Excel data. Invalid record ID.

Error in ==> E:\MATLAB6p5\toolbox\matlab\iofun\private\biffparse.dll
Error in ==> E:\MATLAB6p5\toolbox\matlab\iofun\xlsread.m
On line 90 ==> [n, s] = biffparse(biffvector, names{1});

But if the excel file contains only numerical data, it is okey. So what is the problem? Thank you so much!

 
Okey. I found it out by searching. It is a bug for BIFFREAD function in Matlab release R13. It has been fixed in release R14.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top