why my excel file can not be read by matlab?
169 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Image Analyst
el 16 de Mzo. de 2022
@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.
Respuestas (3)
Milad
el 5 de Mayo de 2016
Editada: Milad
el 5 de Mayo de 2016
7 comentarios
S Deligeorges
el 31 de Mzo. de 2021
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
el 26 de Sept. de 2022
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
Image Analyst
el 5 de Mayo de 2016
Try using readtable() instead
t = readtable('whatever.xlsx');
1 comentario
Elson Leung
el 27 de Mzo. de 2023
Well I am facing the same issue there, I've tried readtable, readmatrix and the rest of possible solution. All of them didnt work.
But the obvious solution is close the excel first, MATLAB apparently cannot read excel while it is opened.
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!