'WorkbookActivate' error with xlsread

3 Ansichten (letzte 30 Tage)
Gordon Fox
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
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.

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Sudarshan
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
Gordon Fox
Gordon Fox am 6 Dez. 2022
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.
Sudarshan
Sudarshan am 7 Dez. 2022
Thanks for the suggestion. Added the link to a separate comment.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Produkte


Version

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by