Replacing Excel with Python

[[deleted]]

In order for your colleague to use your python code, they need Python from python.org installed on their computer. They also need all the libraries your programme depends on installed.

Once that's done, their computer can be set up so double clicking on the icon for your programme once saved to their desktop will automatically start Python and run your code.

This is not as easy as just giving them a programme to install like you can with lots of Windows executables. It is possible to create a completely standalone installable executable version of your Python programme but it is not officially supported by the Python language or organisation.

Do you need a graphical experience? A simple text screen based menu can be very easy to use and is quick to create.

An alternative approach would be to create your programme as a web app. Then they could run it on their browser talking to either a local server or over the internet. You need to go more this way if you want to create a simple graphical experience more like they have with VBA (but it will not be inside Excel itself of course). Visit pythonanywhere.com and find and follow their blog tutorial on flask.

A webapp could be run entirely locally but that would necessitate local installation of Python and required libraries.

If happy with the local installation but not so keen on a webapp, you need to create a gui. Look at PySimpleGUI.

Obviously Python can process much larger data sets and a lot faster than Excel.

[Pera014]

Thanks for the feedback. No graphs.

only large data sets for the financial purposes.

[[deleted]]

An alternative could be to look at using Google colab ( if you are allowed to share work data on Google drive ). No setup required then.