I’m not entirely sure of your full workflow, so it’s a bit tricky to suggest the perfect solution. That said, based on my experience, the capabilities of Python libraries for Excel operations can be quite limited. Are you trying to do things like merging files, merging sheets, or adding sheets? If so, there’s an Excel automation tool called SheetFlash that might be worth looking into.

It works a bit like a Python notebook—you can set up each action as a card, and then simply press the “Run All” button to execute all the actions in one go. It’s an add-in that could potentially solve your issue.