XLSread error started?

3 views (last 30 days)
Ben Sheard
Ben Sheard on 19 Sep 2017
Commented: Ben Sheard on 20 Sep 2017
I keep getting this error
Error using xlsread (line 260)
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Open method of Workbooks class failed
Help File: xlmain11.chm
Help Context ID: 0
The script worked before, I changed a few values in my excel file and now I've got this error every time.
Any ideas why?
I've tried clearing the COM ADD INs in excel, restarted my PC a few times, made sure no other programs are running the same time as matlab, my file is directly in the working directory so it isn't a file path problem, any other ideas?
It's very frustrating!
  2 Comments
Walter Roberson
Walter Roberson on 19 Sep 2017
https://www.mathworks.com/matlabcentral/answers/35316-xlsread-error#answer_44274 might help debug the problem. See also my response right under that.
Ben Sheard
Ben Sheard on 20 Sep 2017
Hi Walter, Thank you for the response!
I came to my PC this morning and ran my script to find that it now works... I haven;t changed anything since last night other than restart my PC, which I also tried yesterday.
Very strange, I'm now hoping it doesn't break randomly again!

Sign in to comment.

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!