I have trouble with read excel data sheet

I have trouble when i use 'xlsread' function

When i run, i got a meassage like 'Can not activate Excel worksheet'.

I checked my excel worksheet file and path of my excel file.

How can i solve this problem?

[Cris LaPierre]

Share your code, the full error message (all the red text), and your file. You can attach it using the paperclip icon.

Also, note this warning at the top of the xlsread documenation page:

xlsread is not recommended. Use readtable, readmatrix, or readcell instead. For more information, see Compatibility Considerations.

Answer 1

[Anjaneyulu Bairi]

The "xlsread" function is not recommended for reading data. Instead, you can use the "readtable," "readmatrix," or "readcell" functions to read data from an Excel file. Please use these functions and see if you are getting any error.

Please refer to the documentations provided below for more information on "xlsread", "readtable," "readmatrix," and "readcell" functions.

• Documentation link to “xlsread” function: https://www.mathworks.com/help/matlab/ref/xlsread.html
• Documentation link to “readtable” function: https://www.mathworks.com/help/matlab/ref/readtable.html
• Documentation link to “readmatrix” function: https://www.mathworks.com/help/matlab/ref/readmatrix.html
• Documentation link to “readcell” function: https://www.mathworks.com/help/matlab/ref/readcell.html