r/Python • • Dec 14 '17

MS is considering official Python integration with Excel, and is asking for input

Post image
4.6k Upvotes

383 comments sorted by

View all comments

Show parent comments

52

u/decimated_napkin Dec 14 '17

Your last sentence is the only reason why Python for Excel is viable imo. If there weren't such a glut of legacy workbooks and lack of programmers, Excel wouldn't have much that Python couldn't do better.

0

u/[deleted] Dec 14 '17

[deleted]

0

u/[deleted] Dec 14 '17

[deleted]

13

u/bjorneylol Dec 14 '17

Not really, I regularly deal with vendors at work who submit data feeds to us in CSV/Excel format. I need to standardize these before importing them into our system and I find that every row has a different error.

I do a lot of preprocessing in excel but for manually changing single cells or concatenating subsets of rows python will never be faster.

The only thing python integration would mean is that I would finally write helper functions for 20 second tasks I do frequently that aren't worth the time investment to write/debug in VBA

→ More replies (6)