title: openpyxl - populating a column using a list
body: <p>So I have been trying to use openpyxl with my Python 3.5 project to produce an excel file that has the top row(B1 to M1) being Months and the column(A2 to length of list) being items from a list I have. Now I can get the top row working fine using this:</p>
  
  <pre><code>for row in ws1.iter_rows('B1:M1'):
      counter=0
      for cell in row:
        cell.value = months[counter]
        counter=counter+1
  </code></pre>
  
  <p>However I cannot use the same method to populate the column. I have tried:</p>
  
  <pre><code>for row in range(2, 1 + len(firstNameList)):
      test=0
      for col in range(1, 2):
          test2 = firstNameList[test]
          ws1.cell(column=col, row=row, value=test2)
          test = test + 1
  </code></pre>
  
  <p>This however does not pull all item from my list but only pulls the first item over and over again. The counter called test is not being incremented for some reason. I also tried using ws1.iter_rows('A2:A15') but this also only pulls the first item from my list(firstNameList). I am very new to using openpyxl and would appreciate any help.</p>
  
  <p>Thanks!</p>