I learned different framework and languages, however, Python seems the best one of them when creating quick and simple code. But before I was reluctant to pick due to spaces counting as a syntax error which caused me grief.
Indeed Python is a great language for quick and advanced automation. Openpyxl, for instance, is an amazing opensource python library for working with Excel formatted document