清空筛选条件
清空筛选条件

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:

1 次查看（过去 30 天）
Vishal
Vishal 2013-4-18
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.

请先登录，再回答此问题。

采纳的回答

Vishal
Vishal 2013-4-23
Iman,i am still getting the same error.

更多回答（1 个）

Iman Ansari
Iman Ansari 2013-4-19
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');

类别

在 Help Center 和 File Exchange 中查找有关 Migrate GUIDE Apps 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by