Teaching analytics with modern Excel
pandas and openpyxlIn an earlier post I wrote about the role of Python in modern Excel and what spreadsheets users stand to gain by learning the programming language: In this post, we'll compare and contrast two …
Continue Reading about How to use Python and Excel together with pandas and openpyxl →
xlwings add-in for ExcelMany packages exist for working with Python and Excel, but xlwings may be the most powerful all-around due to its many reading and writing features. This versatility, however, comes at the cost of …
Continue Reading about How to install the xlwings add-in for Excel →
If you’re just getting started with building reports and other analyses in Excel using Python, it be can be confusing to see how all the steps and packages fit together. This post and accompanying …
