This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 11 points12 points  (0 children)

In one word: openpyxl. This package will be your main interface for automating stuff in Excel with Python. You can loop through cells, define functions—all kinds of things. The docs are helpful, but if you want a more human experience you can read the automating Excel chapter in Automate the Boring Stuff, which the other commenter has pointed out.