title: Python google spreadsheet update in the wrong column
body: <p>I'm trying to update my google spreadsheet with python. Unfortunately my code always updates one column/cell to the left.</p>
  <p>My code:</p>
  <pre><code>headers = wks2.row_values(7)
  colToUpdate = headers.index(&quot;12.11.&quot;)
  
  
  #find the char
  cellLookup = wks2.find('Gul')
  # get the cell to be updated
  cellToUpdate = wks2.cell(cellLookup.row, colToUpdate)
  
  # update the cell's value
  cellToUpdate.value = 3
  # put it in the queue
  cell_list.append(cellToUpdate)
  # now, do it
  wks2.update_cells(cell_list)
  </code></pre>
  <p><code>print(cell_list)</code> outputs [&lt;Cell R8C6 3&gt;]
  but it it should be / it want it to be R8C7.</p>
  <p>Can I change that he starts to count at 1 or just add +1 or something similar?</p>
  <p>I've added a image of my spreadsheet.</p>
  <p><a href="https://i.stack.imgur.com/I1Jet.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/I1Jet.jpg" alt="google spreadsheet screenshot" /></a></p>
  <p>If you need more information, feel free to ask!</p>