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 件のコメント

Guillaume
Guillaume 2018 年 4 月 17 日
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
Guillaume
Guillaume 2018 年 4 月 18 日
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 件)

カテゴリ

製品

タグ

質問済み:

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