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.

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

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 ...