How to use Python and Excel together with pandas and openpyxl

In 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 essential packages using Python with Excel: pandas and openpyxl. Why pandas for Excel? If you’re working with any kind of tabular … Continue reading How to use Python and Excel together with pandas and openpyxl