Open password protected Excel File with Python+Keyboard Maestro

Good Afternoon,
I am new to Keyboard Maestro but I thought it could help me with the following task.
I have a Python routine that daily opens a series of Excel Workbooks, reads them and saves the content somewhere else.

Some of these worksheets are password protected, so the Excel GUI opens up asking for the password, and the Python script is stuck until I insert the password and click OK, then it can move on to the next worksheet.

There apparently is no way to automatically insert the password with Python, so I thought that instead I could tell Keyboard Maestro to put it in automatically and click ok.

I have however no idea if it can be done, and how.

Any idea?