'WorkbookActivate' error with xlsread
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Gordon Fox
am 2 Dez. 2022
Kommentiert: Sudarshan
am 7 Dez. 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 Kommentar
Sudarshan
am 7 Dez. 2022
For this particular problem, refer to the following link.
There are additional links related to "xlsread" for those who want to learn more.
Akzeptierte Antwort
Sudarshan
am 5 Dez. 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!