error using xlsread command in matlab
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Walter Roberson
el 27 de Nov. de 2012
Is there a chart in the .xls file? Is there anything other than plain data?
Respuesta aceptada
Walter Roberson
el 27 de Nov. de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!