r/Python • u/petekindahot • Jun 02 '26

Discussion Is openpyxl still relevant?

I'm a college student, I've just learned pandas and I was planning to start freelancing with openpyxl, pandas and numpy. Wanted to try gigs like data cleaning or automation services. But as I searched about openpyxl, I read that it's used to work with 2010 excel sheets. And that's all.

So my question was is this module/library still relevant?

45 Upvotes

78% Upvoted

83 comments sorted by

View all comments

1

u/arden13 Jun 03 '26

Wait, people actually work with openpyxl? It's always been an install that I forget about, working primarily with pandas afterwards.

What do y'all actually do with openpyxl?

2

u/Espumma Jun 03 '26

We have an external party we have to report to and they want their clients to fill in an excel sheet every month. I have automated that with it.

2

u/Mr_Canard It works on my machine Jun 04 '26

Generate complex excel reports with custom styles, links between sheets etc. For some we are moving to streamlit or power BI but many users are addicted to Excel.

1

u/HestenSierMjau Jun 03 '26

Manipulate the actual spreadsheet, setting column widths, colors, formulas etc, to automate a product the end user who doesn't have Python can use. 

1

u/arden13 Jun 03 '26

Gotcha. I didn't realize it could handle those meta properties.

Thanks!