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

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 2018년 4월 17일
편집: Guillaume 2018년 4월 18일
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');
David Frew
David Frew 2018년 4월 19일
should I copy this directly into the script? or put the file name into it?
Walter Roberson
Walter Roberson 2018년 4월 19일
You can do those at the command line. They are steps for debugging purposes.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

도움말 센터File Exchange에서 Debugging and Analysis에 대해 자세히 알아보기

제품

태그

질문:

2018년 4월 17일

댓글:

2018년 4월 19일

Community Treasure Hunt

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

Start Hunting!

Translated by