This can be too late to answer but the capabilities that Python libraries do for Excel are very limited based on my experience.

Intead, SheetFlash, which is my favorite Excel add-in, can be your solution. You don't have to write any codings but you can set up the automation workflows within Excel. You don't need to learn coding.