title: how to get the current row index with Openpyxl
body: <p>I wrote a Python script to extract some string values from a .json file, store them in some dictionnary and fill them in an .xlsx file using Openpyxl, which I use for the 1st time:</p>
  
  <p>in short, it looks like that :</p>
  
  <pre><code>WORKBOOK = Workbook()
  WORKSHEET = WORKBOOK.active
  . . .
  . . .
  for PERSON in TEAM_LIST:
      for ITEM in ITEMS[PERSON]:
         if PERSON in REGULAR_LIST:
            PERSON_ITEMS_ROW = (PERSON,ITEM[0],ITEM[1],ITEM[2],ITEM[3],ITEM[4)]
            SHEET.append(PERSON_ITEMS_ROW)    # Fill each row with some PERSON ITEMS
        else:
          PERSON_ITEMS_ROW = (PERSON,ITEM[0],ITEM[1],ITEM[2],ITEM[5],ITEM[6])
          SHEET.append(PERSON_ITEMS_ROW)      # Fill each row with other PERSON ITEMS
  </code></pre>
  
  <p>This code works well (although I am not 100% sure it is correct)</p>
  
  <p>I would like to change backgroud and foreground color of rows selected in the "else" part above, and I don't manage to find a way to do it ;</p>
  
  <p>I know how to apply specific color and font to a specific row : I do it for the 1st row used as the header row, but I don't know how to get the current row index so I could apply specific color and font on each row of "else" section</p>
  
  <p>Any idea is welcome</p>
  
  <p>thanks</p>