'WorkbookActivate' error with xlsread

1 次查看（过去 30 天）
Gordon Fox
Gordon Fox 2022-12-2
评论： Sudarshan 2022-12-7
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
Sudarshan 2022-12-7
For this particular problem, refer to the following link.
https://www.mathworks.com/matlabcentral/answers/268668-getting-error-from-xlsread#answer_243627
There are additional links related to "xlsread" for those who want to learn more.

请先登录，再进行评论。

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

采纳的回答

Sudarshan
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”:
https://www.mathworks.com/help/matlab/ref/readmatrix.html?searchHighlight=readmatrix&s_tid=srchtitle_readmatrix_1
Here are some useful links to where the issue has been discussed in the past.
https://in.mathworks.com/matlabcentral/answers/1685374-why-do-i-see-the-rpc-server-is-unavailable-or-the-remote-procedure-call-failed-when-calling-mat#:~:text=The%20reason%20that%20you%20are,MATLAB%20as%20a%20COM%20server
https://in.mathworks.com/matlabcentral/answers/268668-getting-error-from-xlsread
  4 个评论
显示 2更早的评论
Gordon Fox
Gordon Fox 2022-12-6
Sudarshan, so that other users can clearly see what worked, can you please comment with the following link Then, I will accept that as the correct answer. The other links in your post do not solve this particular problem.
https://www.mathworks.com/matlabcentral/answers/268668-getting-error-from-xlsread#answer_243627
Sudarshan
Sudarshan 2022-12-7
Thanks for the suggestion. Added the link to a separate comment.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by