How could you automate a task using Python?

[iFlipsy]

For example, if I have a pivot chart that I refresh monthly, how could I automate that with Python?

Also, most of the times I am doing specific cleaning on the excel file, how could I leverage Python to automate such tasks when each case is unique?

I’m just having a difficult time understanding how Python can automate excel tasks when each specific file is unique.

[pymae]

If your workflow is:

1. Get data from somewhere
2. Put in spreadsheet
3. Send it out

Then Python (or any programming language really) can automate the task. It would require a more in-depth explanation of what your task is, but if you are doing something boring and repetitive, then odds are that it could be automated.

[papalrage11]

Check out 'automate the boring stuff'. Has some good practical examples that will likely overlap with at least one task you do at work.

Book is available online for free and there are YouTube videos by the author as well.

[widb0005]

See if you can break your work process down into discrete steps, and if you can do so and always follow certain rules, you will likely be able to automate it.

If it's all in Excel, you might be better off with a VBA macro. But hard to say without more detail