'WorkbookActivate' error with xlsread
6 次查看(过去 30 天)
显示 更早的评论
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 个评论
Sudarshan
2022-12-7
For this particular problem, refer to the following link.
There are additional links related to "xlsread" for those who want to learn more.
采纳的回答
Sudarshan
2022-12-5
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!