Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski 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
Oct 26, 2005
21
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!

 
Replies continue below

Recommended for you

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