I have been stuck with a very silly problem with xlsread function in MATLAB. Whenever I call the xlsread function the program halts and displays the following error message.
No public field DisplayAlerts exists for class COM.excel_application.
Error in ==> xlsread at 241
Excel.DisplayAlerts = 0;
Can anybody help me in this regard?
what version of MATLAB and MS Excel you are using? On what OS (Windows or MAC?)
No problem is not solved...Was using MATLAB 2009b and Office 2007...As I dont want to waste after that problem I abandoned the old compu and taken a new one...And its in my lab only...
ok..u can send a working example of what you are trying to read and with your commands..i will look into it when get time..looks like though that your COM server is not acting properly
yes the COM server is not acting properly...in my present compu the xlsread is working fine...so there is no prob at all with the code...
M reading shape files in mat lab but i didn't got all fields in that sahpe file . So any body can help to me
I am having a similar issue. Matlab R2009b and Excel 2010. When I call xlsread, I get an error that says "The operating system is not presently configured to run this application", which I assume refers to starting Excel as a COM server from Matlab. It worked previously, then it stopped working. I didn't change anything, so I must assume the change was something in operating system/Office due to an update or somesuch.
Try to find and to remove Duplicate Files "xlsread.m"
Use the attachment file. It works very well with matlab 2013a, excel 2010.
Hi Van, unfortunately those files don't work for me. My version of Matlab is 2009a.
> In uiopen at 62
??? Undefined variable "matlab" or class
"matlab.io.internal.xlsreadSupportedExtensions".
Error in ==> xlsread at 132
openXMLmode = any(strcmp(ext,
matlab.io.internal.xlsreadSupportedExtensions('SupportedOfficeOpenXMLOnly')));
Hi, Dear Sandipan
num = xlsread(filename);
https://www.mathworks.com/help/matlab/ref/xlsread.html
- Badges
- Science topic