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.
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
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.