MATLAB Answers

Could not start Excel server for import

80 views (last 30 days)
Elvis.zwx
Elvis.zwx on 19 Aug 2016
Edited: Guillaume on 3 Nov 2017
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 Comments

Sign in to comment.

Answers (2)

Guillaume
Guillaume on 19 Aug 2016
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 Comments

Elvis.zwx
Elvis.zwx on 19 Aug 2016
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
Guillaume on 19 Aug 2016
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.

Sign in to comment.


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!