Could not start Excel server for import

my m code is [a,b]=xlsread('定增数据201201至20160630.xlsx'); when running it, it goes with

'Warning: Could not start Excel server for import, 'basic' mode will be used. Refer to HELP XLSREAD for more information. '

and this code was available until I upgraded windows  today. After I upgraded, it can also import data, but it has this warning message and the data imported is not the same as it is in excel. that's bothered, the matlab help document says

'basic'   Flag to request reading in basic mode, which is the default for systems without Excel for Windows.

who can help me out? thank you.

Answer 1

[Guillaume]

Matlab is telling you it can't talk to excel. Since you upgraded Windows, it's possible that it messed up the excel installation, so I would try repairing or reinstalling excel.

[Elvis.zwx]

yes，I have reinstalled excel, but it doesn't help, so I am really wondering what else I can do to settle this problem.

[Guillaume]

What does

excel = actxserver('Excel.Application')

returns?

If it does error, then the problem is most likely with excel's installation, not matlab. You'd get the same error if you were trying to automate excel from vb, .Net, etc.

Answer 2

[Johnson Chen]

https://cn.mathworks.com/matlabcentral/answers/19264-problems-starting-excel-server