INNER CODE UNIT · Python
first_col
fzumstein/python-for-excel · sales_report_xlsxwriter.py:75
first_col=startcol + 1,
last_row=startrow + nrows,
last_col=startcol + ncols,
options={
"type": "cell",
"criteria": "<=",
"value": 20000,
"format": below_target_format,
},
)
# Chart
chart = book.add_chart({"type": "column"})
chart.set_title({"name": "Sales per Month and Store"})
chart.set_size({"width": 830, "height": 450})
# Add each column as a series, ignoring total row and col
for col in range(1, ncols):