title: how to iterate excel values in pywinauto automation script
body: <p>In the below code i am trying to read stream names from excel one by one and play all the streams continuously automatically using pywinauto...but i could read all streams from excel and print it  but play only the first stream... How to play set of streams continuously?</p>
  <p><a href="https://i.stack.imgur.com/sVyGA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sVyGA.png" alt="enter image description here" /></a></p>
  <pre><code>filename = &quot;read_output_sheet.xlsx&quot;
  
  wb = openpyxl.load_workbook(filename)
  sheet1 = wb.worksheets[0]
  sheet1.title = &quot;TEST_SHEET_1&quot;
  
  def play():
      global stream_name
      path=os.path.realpath(&quot;D:\\STREAMS\PCM&quot;) 
      os.startfile(path) # open the folder named &quot;pcm_streams&quot;
      app = pywinauto.Desktop(backend='uia').window(best_match='PCM')
      time.sleep(1)
      win = app.window(title_re = stream_name, found_index=0) #'pcm48k_org'   str(stream_name)
      time.sleep(1)
      win.click_input(button='left')
      win.click_input(button='right') # right click on one file listed there
      app1 = pywinauto.Desktop(backend='uia').window(best_match='ContextMenu',top_level_only = True)
      win1 = app1.window(title_re=&quot;Open with&quot;)#Open with
      win1.click_input()  # click on &quot;Open with&quot; context menu
      app2 = Desktop(backend='win32')
      app2.PopupMenu.menu_item('foobar2000').click_input()
      
      
  row_num = 3
  i = 1
  while(1):
      if sheet1.cell(i + row_num, 3).value is None:
          break
          
      else:
          stream_name = sheet1.cell(i + row_num, 3).value 
          print(stream_name)      
          play()  
          i +=1
  
  wb.save(filename)
  </code></pre>