'WorkbookActivate' error with xlsread
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Gordon Fox
el 2 de Dic. de 2022
Comentada: Sudarshan
el 7 de Dic. de 2022
When I try to read in a csv file with xlsread, I first got an error that the RPC server was unavailable. After some digging around on this site, I added a pause(10) command after xlsread, and now I get this error message:
Error using xlsread
Error registering events. 'WorkbookActivate' is not a valid event name.
I tried saving the csv as a xlsx file. I have tried using readcell and readtable, but they don't capture all of the data that I need from the csv file. I could write what I need with low-level io, but I used to use xlsread all the time, so I don't want to have to abandon that.
This error happens with both matlab R2020a and 2022b. My computer is running Microsoft Excel 2016. Any help is appreciated! Thank you!
1 comentario
Sudarshan
el 7 de Dic. de 2022
For this particular problem, refer to the following link.
There are additional links related to "xlsread" for those who want to learn more.
Respuesta aceptada
Sudarshan
el 5 de Dic. de 2022
Hi Gordon,
The “xlsread” function has not been recommended for use since R2019. A possible workaround is to modify your code to use one of the functions “readmatrix” or “readtable”, both of which read XLS files but return a matrix and a table respectively.
Refer to the below documentation for more info on “readmatrix”:
Here are some useful links to where the issue has been discussed in the past.
4 comentarios
Más respuestas (0)
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!