block by palewire 381bd617d1d41e18b3b71f1755dbd9ed

How to open Excel files in Python without pandas

How to open Excel files in Python without pandas

The pandas data-analysis tool can do almost everything. And because it can do almost everything, it’s a massive hunk of code. So you might not want to include it in your project if you can avoid taking on the weight.

One of pandas’ handiest features is quickly opening Excel spreadsheets. If that’s all you need, here’s how to accomplish the task with openpyxl, a much lighter dependency.

example.xlsx

with-pandas.py

without-pandas.py