Error involving 2018a xlsread

I just updated to the new Matlab 2018a and now my xlsread function does not work and this is the error I am receiving. I have two sheets in the Data.xlsx file and want to pull the data from the code given but it gives the shown.
Error using xlsread (line 260) Error registering event(s), Invalid ConnectionPointContainer
Error in lab5 (line 8) drag = xlsread('Data.xlsx',1,'d25:d122');

5 Comments

Can you:
  • type dbstop if caught error in the command line
  • try your xlsread again
  • tell us on which line of which file it breaks in the debugger
Since dbstop if caught error can get annoying very quickly, to return to normal operation, type
dbclear if caught error
afterward.
David Frew
David Frew on 17 Apr 2018
Edited: Guillaume on 18 Apr 2018
it shows an error at line 18 of matlab.io.internal.getExcelInstance, called from line 196 of xlsread
What happens if you execute these two lines:
excel = actxserver('Excel.Application');
version = get(excel, 'Version');
should I copy this directly into the script? or put the file name into it?
You can do those at the command line. They are steps for debugging purposes.

Sign in to comment.

Answers (0)

Categories

Products

Tags

Asked:

on 17 Apr 2018

Commented:

on 19 Apr 2018

Community Treasure Hunt

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

Start Hunting!