Generating Excel's What-If Analyses Data Tables in Python

As I was researching ways to use Python and automate my processes as a corporate valuation specialist, one snag that I hit was setting up these data/scenario analysis tables.

I genuinely spent hours trying to get some kind of lead on it, but the only option I found was a proprietary Excel/XLSX API. However, I wasn’t planning on giving up so quickly...