Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

That’s the concept behind Xlwings, a BSD-licensed Python library that connects to Excel and allows Excel spreadsheets and Python applications to interact directly.

If all of those conditions are met, users can go to Microsoft's Python in Excel site to get started, which requires being in the Microsoft 365 Insiders program and using the Beta Channel in Excel for ...