Excel is just xml file. What I do is design the excel file how I need it. Export/Save as XML then use jinja2 and template it.

First sheet is usually raw data in standard rows/columns, second sheet would have the cells I need, etc a cell for sum of x columns from sheet 1.

Then use panda’s to get the data, and feed it through jinja2’s template render function.