error using xlsread command in matlab
1 view (last 30 days)
Show older comments
I have written in my matlab program:
EnergyfromSun = xlsread('C:\Homa\Thesis\Matlab\SC\ASTMG173num.xls'); but I got this message:
??? No appropriate method, property, or field UsedRange for class Interface.Microsoft_Excel_14.0_Object_Library._Chart.
Error in ==> xlsread at 302 DataRange = Excel.ActiveSheet.UsedRange;
Error in ==> T2011 at 10 EnergyfromSun = xlsread('C:\Homa\Thesis\Matlab\SC\ASTMG173num.xls');
>> This excel sheet has 2 columns and 2002 rows and I am using matlab 7.11.0 version Please help me, I am too confused. Thanks Homa
4 Comments
Walter Roberson
on 27 Nov 2012
Is there a chart in the .xls file? Is there anything other than plain data?
Accepted Answer
Walter Roberson
on 27 Nov 2012
The error message is complaining that UsedRange does not apply to charts. I do not know enough about Excel to know what the solution is, other than to delete the chart. Possibly if you specify the range of rows/columns that might solve the problem.
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!