XLSread error started?

2 次查看（过去 30 天）

Ben Sheard 2017-9-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/357404-xlsread-error-started

评论： Ben Sheard 2017-9-20

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 个评论
显示无隐藏无

Walter Roberson 2017-9-19

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 2017-9-20

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!

请先登录，再进行评论。

请先登录，再回答此问题。