The reason behind this issue can be the call from MATLAB to Excel to read an Excel file using COM component failed and Excel was not able to read the file Successfully. One of the possible reason behind this issue is that the Excel file you are trying to read is corrupted. Please make sure that the file can be opened and viewed from outside of MATLAB using Microsoft Excel, before reading it using "xlsread".
This error message can also be thrown because of the COM/ActiveX layer that is started by "xlsread". In particular, Excel is not able to allocate enough memory when it attempts to copy large amounts of data for transfer into MATLAB, and MATLAB is re-throwing the error in the Command Window.
You can try performing the following steps and check if the error gets eliminated or not:
1) This error may occur if a file with macros is saved in Excel 2003 and then used with Excel 2007, Excel 2010 or Excel 2013. The issue may be resolved by first opening the file with Excel 2007, 2010 or 2013 and re-saving.
2) Place the Excel file in the local directory. If the file is on a shared network, it could be open in a program or in use by users. A possible workaround would be to change the location of the Excel workbook to a local directory from a mapped network drive.
3) Run the Disk Cleanup by navigating to Start, type "Disk Cleanup" and remove only the "Temporary files" by checking only that option.
I hope this helps.
