Question: I have been working with excel vba for some period of time related with automation. Now I am planning to upgrade to python. I did a little bit of research on how to implement automation using python. All I see people doing coding with PyCharm or Jupiter, to do an automation user has to have knowledge of python. What I want to know is how to create a tool or standalone application with python that does a repetitive task, calculation or report generation in excel. Where the end user doesn't have to worry about python or codes or learning new technology to accomplish the task.

Answer: 
I know this isn't technically and answer, and since I can't comment yet (too low rep), I'm going to point you to [automate the boring stuff with python](https://automatetheboringstuff.com/). I'm sure you can find your answer here plus some!
Here is my answer.

<https://github.com/TaeYoon2/ExcelAutomation>

This project is a sample excel automation program with python.

I used 'openpyxl' library.