5 Excel chores worth automating with Python (and how to tell which ones aren't)

Most "Excel problems" I get asked about are not Excel problems. They are the same five boring steps someone does every Monday by hand. Here is how I decide whether a task is worth scripting, and the small Python patterns that cover most of them. 1. Count the clicks, not the rows A 200,000-row file that you open once a year does not need a script.... Weiterlesen: 5 Excel chores worth automating with Python (and how to tell which on…