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.
2
-
1Make a Tkinter GUI to perform the operations you desire. You could refer this medium.com/@medasuryatej/… or the automate the boring stuff with pythonSurya Tej– Surya Tej2019-10-22 20:49:09 +00:00Commented Oct 22, 2019 at 20:49
-
If you are looking for some Excel plugins type thing, you might try xlwings.org -- For a true standalone, I really like PyQt5 for my native desktop apps (I.E. not within Excel, but modifying .xlsx files)David Culbreth– David Culbreth2019-10-22 21:05:10 +00:00Commented Oct 22, 2019 at 21:05
Add a comment
|
2 Answers
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. I'm sure you can find your answer here plus some!
Comments
welcome to stackoverflow. Here are a few resources that hopefully get you started on your journey to automating excel tasks with python then wrapping your project up for non-python users.
Python libraries that interface with excel (these are for you to write your excel automation projects)
- openpyxl docs
- pandas docs
- pylightxl docs
- more at http://www.python-excel.org/
Wrapping up your project for non-programmers
There are a few options here for your non-programmer users.
- Have users run your python project on command line where you give them prompts to respond to for your automation (ie. input excel file name, automation task inputs etc). This is probably the simplest task on your end, but it does expect your users to know how to user command line.
- Have users run your python project on command line but you create a graphical user interface (GUI) for them to ease the input field options. This requires some up front work on your end to wrap you input with a GUI of your choice; here are a few tkinter, pyqt.
Note that both of these options require your users to have python on their machine with the proper packages ready to go to execute your project. This can be a lot to ask for non-python users. Therefore finally you could use a packaging software like pyinstaller to wrap up your python project into an .exe
Hope that helps! Happy pythoning
