How can I read from file with loop ?

Hello to all, I am trying to read data from excel file and each 10 second update and plot it. Here is the main part of my m-code, if smb need I can paste the whole code.

function [x,y] = readExcelColumns (fileName, xColNum, yColNum)
  a= xlsread(fileName);
  x=a(:,xColNum);
  y=a(:,yColNum)

function updateAxes (hObject, eventdata, handles)
xColNum = get(handles.popupmenuX, 'value');
yColNum = get(handles.popupmenuY, 'value');
fileName=handles.fileName;
inf = 1;
* for k=1:1000
[x,y] = readExcelColumns (fileName, xColNum, yColNum)
plot (handles.axes1,x,y)
pause (10);
if k==0
    break;
end
end*

function pushbuttonSTOP_Callback(hObject, eventdata, handles)
inf = 0;

[Azzi Abdelmalek]

i see you have a code, can you specify your problem?

[Sriram]

where you got stuck?

[Dzhamshed]

OK, I have a file which updates each 20 sec, and I want to have a plot of some columns, I made a loop for reading file infinitly, but it plots just one time and no more... here is the whole code http://pastebin.com/encDs5XJ

Answer 1

[Sriram]

plot axes is getting updated.. there is no issue on that ... make sure you have x an y variables updates....

   for i = 1:1:10
    x = rand(i);
    y =rand(i);
    plot(handles.axes1,x,y)
    title(i)
    pause(1)
   end

the above sample code (as you did for plot) works fine... so try to make sure whether x and y variables get updated , and also make the delay (pause(10)in your code ) to be minimal when you debug whch ll be helpful...!

[Dzhamshed]

I think x,y updates as I included the function, called [x,y] = readExcelColumns (fileName, xColNum, yColNum) in the loop, but whatever it doesn't update(((

Answer 2

[Dzhamshed]

Sriram, I think x,y updates as I included the function, called [x,y] = readExcelColumns (fileName, xColNum, yColNum) in the loop, but whatever it doesn't update(((

[Sriram]

Though you call the function - try to check in the next xls file your x and y (rows and coloumns) getting updated or not....

Do you get any error?

Does the loop goes on ???

Are you able to open as many - xls files - as the loop proceeds ?

[Dzhamshed]

No it is not getting updated( I tried by xlswrite();

[Sriram]

Fine... hope now you could solve it.... (xlsread will work fine)

[Dzhamshed]

I didn't solve it, it doesn't work, as it was. Could you, please see my source code in order to help me?

Answer 3

[Dzhamshed]

Pls, can anyone help me with this??? (((

[Sriram]

can you attach the .fig (GUI) file