Alternating row color using xlsxwriter in Python 3
<p>Has anybody implemented alternating row color while generating excel using xlsxwriter in Python3?</p>

<pre><code>data_format = workbook.add_format(
    {
        'bg_color': '#FFC7CE'
    })

worksheet.write(data_row, data_col + 1, row[1], data_format)
</code></pre>

<p>This sets the color for each column.</p>