Error loading xls file into MATLAB
I am trying to load an xls file into MATLAB. The xls file contains numeric values. I have downloaded and built the file successfully, but if I change the file size (i.e. row count and column count), there is an error:
Numeric = xlsread('Test_results_new')
??? No appropriate method or public field UsedRange for class Interface.Microsoft_Excel_12.0_Object_Library._Chart.
Note that when I make changes to the xls file, I also make changes to the MATLAB code for the number of rows and columns.
Can anyone help me?
+2
source to share
1 answer
I had the same problem recently after months of continuous running, I found out that it was because I made a plot in an excel file, so (I think) when xlsread was called it was looking at the first sheet (plot instead of table) and obviously couldn't read it. You can tell which sheet to view with xlsread, just type help xlsread and it will explain how
+1
source to share