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.

The cumbersome process of using Python code in Microsoft Excel data-driven projects will soon be eased by the company's new "Python in Excel" initiative, currently in public preview. Integrating the ...

Libraries like openpyxl and xlwings allow Python to interact with Excel files, where you can format cells, create charts, and automate complex calculations and data manipulation.

However, the rise of Python, coupled with its direct integration into Excel and powerful libraries like openpyxl, xlwings, and pandas, presents a compelling alternative.