Writing custom python scripts for excel

An example of a python script to split a worksheet into multiple worksheets based on the values in a column.

Installation

Dependencies

• Python
• Pandas pip install pandas
• Openpyxl pip install openpyxl

Installing the source code

1. Clone this github repository by either downloading the zip file or using the following command line command:

git clone https://github.com/GeorgiySav/custom-python-excel-script.git

2. Make sure you have downloaded the dependencies.
3. You can now run and edit the python file.

Converting the python file to a .exe file

1. Install auto py to exe pip install auto-py-to-exe
2. Open the terminal in the folder that contains the source code and run the following command auto-py-to-exe
3. Set the script location to the python file
4. Choose one file if you want a single .exe file without any other files
5. Also set it to be a console application
6. Click convert .py to .exe
7. Your .exe file will be saved in the output folder