While VBA still holds its place, Python’s rise in the Excel automation landscape is undeniable. With its neat integration in Microsoft’s spreadsheet software, it is becoming the new VBA for ...

Instead of using SUM formulas, you can automate it with Python. Once again, you can use Openpyxl to load the workbook, insert formulas, and save changes.

That’s not to say some are outright better than others, but some do have more diverse applications. Python, for example, can be used to build desktop apps or as an automation tool.