Problem accessing Excel files through xlsread

Question

Ari Bronstein 2016-10-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306813-problem-accessing-excel-files-through-xlsread

评论： Allan N 2019-2-23

Hi everyone, I'm trying to open Excel files via MATLAB using xlsread, and this is what I get:

data = xlsread('..\10 Power Curve Test\04 AEP\AEP calculations T94 T107 T149 - Final.xls',16,'C8:F51');
Error using xlsread (line 249)
Error: The server threw an exception.

I've dug down into the code and found the problem line, in OpenExcelWorkbook:

Excel.workbooks.Open(filename, 0, readOnly);

Excel is a COM.Excel_Application object.

When trying to run this line independently of the larger function, I get the following error message:

Error using Interface.000208DB_0000_0000_C000_000000000046/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Sorry, we couldn't find ..\10 Power Curve Test\04 AEP\AEP calculations T94 T107 T149 - Final.xlsx. Is it possible it
was moved, renamed or deleted?
Help File: xlmain11.chm
Help Context ID: 0

However, I know that the file exists, because I can open it with fopen:

fopen('..\10 Power Curve Test\04 AEP\AEP calculations T94 T107 T149 - Final.xlsx')
ans =
       3

I've also tried using xlsread with other files, from within the working directory, and the same problem persists.

Can anyone help me with this? My only idea at this point is to force a Windows update and look for updates to Office and hope that fixes something.

Thanks in advance!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

XM Liu 2016-11-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306813-problem-accessing-excel-files-through-xlsread#answer_243628

1- open the excel> file, >option, >add in, manage then select COM ADD IN, and clear everything (unchecked). everything should be cleared (unchecked). 2- restart the PC, and open the matlab. 3- perform xlsread command.

PS. For those people who use foxit pdf reader, it is potential to face this problem, so follow mentioned order.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ari Bronstein 2016-11-17

This is it! I didn't uncheck everything (we have 2 Pi Datalink Add-ins in our office), but I unchecked the FoxitReader PDF Creator Add-in, and it works now!

请先登录，再进行评论。

Answer 2

Soma Ardhanareeswaran 2016-10-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306813-problem-accessing-excel-files-through-xlsread#answer_239957

The error observed might be related to spaces in the file path. Try placing the file in another directory without any spaces and observe for the error.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ari Bronstein 2016-10-21

Thank you for the suggestion. I had high hopes, but no luck; same error.

请先登录，再进行评论。

Answer 3

Jan 2016-10-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/306813-problem-accessing-excel-files-through-xlsread#answer_240112

编辑：Jan 2016-10-21

Try to use an absolute path name instead of the '..' . Using relative paths is okay, but often a cause for confusions, because the current folder might be changed unexpectedly by a callback of a timer or a GUI element.

Look in the comments of http://de.mathworks.com/matlabcentral/fileexchange/10465-xlswrite1: 11 Feb 2015 Kevin Gaukel.

2 个评论
显示无隐藏无

Ari Bronstein 2016-10-21

在 MATLAB Online 中打开

Thank you for the suggestion, but I really don't think the path to the file is the problem. As mentioned before, fopen works fine.

data = xlsread('c:\Users\abronstein\Downloads\AEPFinal.xlsx',16,'C8:F51');
Error using xlsread (line 249)
Error: The server threw an exception.

Allan N 2019-2-23

Did you find a solution to this problem? I, too, am having error on data = xlsread (filename) command. (I am using Win10 with xlsx file with Office 2016). I had no problem with Win7 and Office 2011, and I'm wondering if Excel 2016 does something differently, or perhaps with Win10. Please let me know if you found a solution.

请先登录，再进行评论。