xlsread error after updating to 2016b

Hi! After updating to Version 2016b the xlsread function gives out following error:

Error using xlsread (line 249)
Error: File: xlsreadCOM.m Line: 113 Column: 12
Arguments to IMPORT must either end with ".*" or else specify a fully qualified class name:
"matlab.io.spreadsheet.internal.columnLetter" fails this test.

With the Version 2015b the function worked fine! Can anyone help?

Thanks a lot. Cheers, Chris

[Steven Lord]

What is the output of the following commands?

which -all xlsread

which -all matlab.io.spreadsheet.internal.columnLetter

CL = which('matlab.io.spreadsheet.internal.columnLetter');
P = path;
pCL = fileparts(CL);
packagepart = findstr(CL, '+matlab');
if ~isempty(CL)
  CL = CL(1:packagepart-2);
end
isOnPath = strfind(P, CL)

[Angelo (Scotty) Gilmore]

I am getting the same error on something which used to work fine. I ran the code Steven Lord posted and this is what I got:

which -all xlsread
which -all matlab.io.spreadsheet.internal.columnLetter
CL = which('matlab.io.spreadsheet.internal.columnLetter');
P = path;
pCL = fileparts(CL);
packagepart = findstr(CL, '+matlab');
if ~isempty(CL)
  CL = CL(1:packagepart-2);
end
isOnPath = strfind(P, CL)

C:\Program Files\MATLAB\R2016b\toolbox\matlab\iofun\xlsread.m
'matlab.io.spreadsheet.internal.columnLetter' not found.

isOnPath =

       []

[Jeremy Hughes]

This sounds like an installation issue. A fresh reinstall of MATLAB will likely fix the issue. If that doesn't work, you should contact support.

[Harm]

Hi, got the same issue on my 2016b. 2016a works fine. Can anyone confirm the reinstall is the fix for this?

[per isakson]

Steven's code give the same result on my R2016a

C:\Program Files\MATLAB\R2016a\toolbox\matlab\iofun\xlsread.m
'matlab.io.spreadsheet.internal.columnLetter' not found.
isOnPath =
     []
>> version
ans =
9.0.0.341360 (R2016a)

[Harm]

For me, a full deinstall and reinstall of 2016b solved this problem. The code from Steve no longer results in an empty value.

Answer 1

[Henrique]

Try to restore Matlab path to its default with the commands:

>> restoredefaultpath

>> rehash toolboxcache

>> savepath

I had exactly the same problem as yours and restoring the path solved it.

[Antoni]

I had the same problem with 2017a version and your proposed solution works perfectly. Thanks.

[linghao x]

This also solves my error:

Error using print (line 83)
Error: File: datestr.m Line: 126 Column: 8
The import statement 'import matlab.internal.datatypes.stringToLegacyText' cannot be found or cannot be imported. Imported
names must end with '.*' or be fully qualified.

Error in saveas (line 181)
        print( h, name, ['-d' dev{i}] )

Error in main_v4 (line 210)
saveas(gcf,'step2wc0_effect.png');

Thanks so much!

[Robert Mills]

Bingo

Answer 2

[Youssef]

I have the same issue, and used the restore commands, but now it gives me empty data file. the loading fails to bring data. Does anyone have a solution?

Thanks.

[Youssef]

Thanks. I figure ot the error. The restore commands worked well.