INNER CODE UNIT · Python
first_row
fzumstein/python-for-excel · sales_report_xlsxwriter.py:74
first_row=startrow + 1,
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