xlwings - xlwings is an open-source Python library that makes it easy to automate Excel with Python. It works great for reporting, unit tests and user defined functions (UDFs).

https://www.xlwings.org/