Could not start Excel server for import

Question

Elvis.zwx 2016-8-19

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300134-could-not-start-excel-server-for-import

编辑： Guillaume 2017-11-3

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Guillaume 2016-8-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/300134-could-not-start-excel-server-for-import#answer_232232

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.

2 个评论
显示无隐藏无

Elvis.zwx 2016-8-19

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 2016-8-19

在 MATLAB Online 中打开

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.

请先登录，再进行评论。