title: Applying formatting row by row in addition to column formatting with xlsxwriter
body: <p>I am formatting all of my columns in an excel file using the xlsxwriter module:</p>
  
  <pre><code>def to_excel(video_report, feed):
      # Create a Pandas Excel writer using XlsxWriter as the engine.
      writer = pd.ExcelWriter('daily_report.xlsx', engine='xlsxwriter')
  
      # Convert the dataframe to an XlsxWriter Excel object.
      video_report.to_excel(writer, sheet_name='Video Overview', na_rep="-")
  
      # Get the xlsxwriter objects from the dataframe writer object.
      workbook = writer.book
      worksheet = writer.sheets['Video Overview']
  
      # Add some cell formats.
      integer = workbook.add_format({'num_format': '0', 'align': 'center'})
      decimal = workbook.add_format({'num_format': '0.00', 'align': 'center'})
      percentage = workbook.add_format({'num_format': '0.0%', 'align': 'center'})
  
      zebra = workbook.add_format({'bold': True})
  
      worksheet.set_column('B:B', 13, integer)
      worksheet.set_column('C:C', 17, percentage)
      worksheet.set_column('D:D', 19, percentage)
      worksheet.set_column('E:E', 15, integer)
      worksheet.set_column('F:F', 15, percentage)
      worksheet.set_column('G:G', 15, decimal)
      worksheet.set_column('H:H', 13, integer)
      worksheet.set_column('I:I', 13, integer)
      worksheet.set_column('J:J', 13, integer)
      worksheet.set_column('K:K', 13, integer)
      worksheet.set_column('L:L', 13, integer)
  
      worksheet.set_row(3, 20, zebra)
  
      feed.to_excel(writer, sheet_name='Feed Position', na_rep="-")
  
      workbook1 = writer.book
      worksheet1 = writer.sheets['Feed Position']
  
      integer = workbook1.add_format({'num_format': '0', 'align': 'center'})
  
      worksheet1.set_column('B:HU', 4, integer)
  
      writer.save()
  </code></pre>
  
  <p>I would like to add zebra striping to my rows, but I can't seem to find a way to format row by row, without overwriting my column formatting.  As a test, I created a bold format and applied it to row 3, but it overwrote my column formatting  Is it possible to add row by row formatting without overwriting my column by column formatting?  Or maybe there is an idiom for zebra striping that would avoid the row by row formatting?</p>
  
  <p>EDIT:  I think my situation becomes more difficult because the data is already written to excel via a pandas function.  Is there anyway around this that would make formatting both rows and columns easier?</p>