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.

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.