title: Edit Excel sheet in a python loop
body: <p>I can edit an Excel file with xlwings:</p>
  
  <pre><code>import xlwings as xw
  
  filepath = ('file.xlsx')
  wb = xw.Workbook(filepath)
  
  sh = 'Sheet1'
  l = ['B6','B7','B8','B9','B10','B11']
  
  for i in range(len(l)):
      xw.Range(sh, l[i]).value = i
  </code></pre>
  
  <p>How can I iterate over rows without having to write a list by Hand? In Addition, is there a way to iterate over columns?</p>
  
  <p>Edit: Editing a cell range works now.</p>
  
  <pre><code>import xlwings as xw
  
  filepath = ('file.xlsx')
  wb = xw.Workbook(filepath)
  
  sh = 'Sheet1'
  l = [8,7,6,5,4,3,2,1]
  
  for i in range(len(l)):
      xw.Range(sh , (3,2),(10,2)).value = l[i]
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/nYJdT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nYJdT.png" alt="enter image description here"></a></p>
  
  <p>Problem: Every cell is changed in the process. How can I Change one, then move to the next?</p>