i am using a for loop to access each element in a column of an xls file and display the data with the help of GUI.my code is:

this code is written in the pushbutton callback:

for i=1:4
    a=xlsread('abc.xls',i,'A(i)');
str=sprintf('%d',a);
set(handles.edit1,'string',str);
end

But i am getting an error:

Error using ==> xlsread at 285
Data range is invalid.

Error in ==> sample>pushbutton1_Callback at 82
    a=xlsread('abc.xls',i,'A(i)');

I am new to matlab. Please help.

Answer 1

[Vishal]

Iman,i am still getting the same error.

[Iman Ansari]

Sorry:

a=xlsread('abc.xls',i,['A' num2str(i)]);

Answer 2

[Iman Ansari]

Hi. Range should be a string:

a=xlsread('abc.xls',i,['A' 'num2str(i)']);

It's better to read the whole file then use it,

a=xlsread('abc.xls',1,'A1:A4');