Example Python codes that do the processes between MySQL database and Excel spreadsheet files.

Structure

Sample data

1. Download Python 3 installation file from https://www.python.org/

2. Install pipenv as global package by this command.

pip install pipenv

Note: for macOS with pre-installed Python 2, use pip3 instead of pip.

1. Download this project.

2. Open PyCharm and choose File -> Open... -> Then select project folder

3. Fix any warning recommended by PyCharm.

4. Make sure that every project packages is installed, by open PyCharm Terminal and type command.

pipenv install

1. Open "main.py", right click on code area, select Run 'main'

2. Program will inform you, to type one file name from "scripts" folder to be run.

1. Download this project

2. Open Terminal or Command Prompt at project folder, then install packages.

pipenv install

1. Activate pipenv environment.

pipenv shell

1. Run "main.py"

python main.py

1. Program will inform you, to type one file name from "scripts" folder to be run.