why my excel file can not be read by matlab?

Question

Milad 2016-5-5

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282688-why-my-excel-file-can-not-be-read-by-matlab

回答： Elson Leung 2023-3-27

I have simple excel file including date and rainfall in two columns. the matlab can not read the file, either import data by xlsread command. I made two format .xls and .xlsx. but matlab has an error. just it can read .csv file. matlab version is 2016a. error message after command Error using xlsread (line 251) Error: The server threw an exception.

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

zhuyuan 2022-3-16

really? i restart three times at least, but no use.

Image Analyst 2022-3-16

@zhuyuan you probably have a hidden Excel server running that just retarting MATLAB won't get rid of. You have to restart your computer, or else if you're using WIndows type control-shift-Esc (to bring up the task manager) and kill it there.

请先登录，再进行评论。

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

Answer 1

Milad 2016-5-5

10
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/282688-why-my-excel-file-can-not-be-read-by-matlab#answer_220925

编辑：Milad 2016-5-5

Who has problem to read excel file, can follow this order. 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.

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

NOTE: sometimes by using the matlab, configuration of excel is changed in unknown way, therefore there is no way to open the usual excel file in windows by double click.

So, open excel from desktop icon, file> option,> advanced,> general and then make clear (unchecked) "the ignore applications that use dynamic data exchange (DDE)". (same information for NOTE 2: https://support.microsoft.com/en-us/kb/3001579) these are some error for excel worker with matlab and related command.

7 个评论
显示 5更早的评论隐藏 5更早的评论

S Deligeorges 2021-3-31

Thank you for the post, it partially solved the problem for me. I was able to open the file once with xlsread, the moment I read the data, the error returned and I can no longer read the data file and get the line 257 error. COM ADD IN unchecked already, can't use the same trick again.

Shahrulnizahani Mohammad Din 2022-9-26

Hi. I am facing the same prpblem.

Toubleshoot efforts:

1) clear (unchecked) the COM Add-in, clear (unchecked) "the ignore applications that use dynamic data exchange (DDE) and restarted the laptop...open MATLAB and try run it..[result : no success]

2) uninstall and re-install MATLAB and retarted the laptop..open MATLAB and try run it..[result : no success]

3) try ti change the xlsx file to xls, open MATLAB and try run it...[result : no success]

4) the the file path and filename (to check typo error)..evertything is in place

5) changed the location (from Dropbox to My Document folder) , reopen MATLANB and try to run the code [result : no success]

6) change xlstead to readtable/ read matrix [result : no success]

Pls help

thanks

请先登录，再进行评论。