Python 3, openPyXl, os, shutil on Windows 10
The Problem
As an academic administrator, I have to prepare 70 empty grade report spreadsheets templates at the end of each academic quarter: one for each of my teachers. Each copy of the template sheet needs to be named with the teacher’s name and class number. Then the quarter, title and year is appended to the end. For example:
Stephen Hawking 404-23 Q3 Grades 2017.xlsx
The hard way would be to copy and paste a file click the file and rename it, repeating the process 70 error-prone and mind wastingly dull times. I could also get the teachers to rename the file, but…they are teachers, not administrators so…yeah…errors again.
Python 3 to the rescue: