http://xlwings.org/

xlwings is a free and open-source alternative to VBA that allows you to program Microsoft Excel with Python. It works on Windows and Mac.