MATLAB: Do I receive “sprint is not defined for class cell” error when I try to read an Excel file using IMPORTDATA in MATLAB

cellclassdefinedexcelforimportdataisMATLABnotsprintf

I receive "sprint is not defined for class cell" error when I try to read an Excel file using IMPORTDATA in MATLAB.

Best Answer

This bug has been fixed in Release 14 Service Pack 3 (R14SP3). For previous product releases, read below for any possible workarounds:

This is a bug in MATLAB 6.5 (R13) in the way that IMPORTDATA handles Excel data files.

One of the reasons for this error could be that the file was created using an unsupported version of Excel.

As a workaround, copy the contents of the file to a new workbook created using a supported version of Microsoft Excel and then try to read that file. Note that you should copy the contents of the file and not do a 'Save As'.

Related Solutions

MATLAB: Having trouble compiling importdata

From the previous MATLAB Answers post which you linked, it seems like it might be important to provide importdata with the full path to the file from uigetfile. You can try combining the FileName and PathName parameters from uigetfile using the fullfile function:

[FileName,PathName] = uigetfile('*.CSV','Select the data file');
fullFilePath = fullfile(PathName, FileName);
delimiterIn = ',';
headerlinesIn = 11;
A = importdata(fullFilePath,delimiterIn,headerlinesIn);

See the fullfile documentation page for more information: https://www.mathworks.com/help/matlab/ref/fullfile.html

MATLAB: Issues using importdata function

Just noticed the same issue after upgrading Matlab from 2013b to 2015a. Seems like the implementation of importdata changed slightly and the new version introduced a function 'fixLineEndings', which apparently needs a lot of memory. Further investigation suggests MathWorks use fixLineEndings() first to convert line ending character(s) to '\n' and use such line ending character in the rest of the code.

I modified the code of importdata.m to avoid calling fixLineEndings() and remove the assumption of line ending character as '\n' in the rest of the code. Then I used pcode() to generate the corresponding importdata.p. Now the memory usage goes back to previous level.

Best Answer

Related Solutions

MATLAB: Having trouble compiling importdata

MATLAB: Issues using importdata function

Related Question