Python x MySQL x Excel by Zinglecode

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

https://www.youtube.com/watch?v=axraNvtHjO4

Setup database table

Structure

Sample data

Install Python 3 and pipenv

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.

Install and run project by PyCharm

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

5. Open "import_data.py" or "export_data.py", right click on code area, select Run '{file name}'

Install and run project by CLI

1. Download this project

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

pipenv install

3. Activate pipenv environment.

pipenv shell

4. Run "import_data.py" or "export_data.py"

python import_data.py

or

python export_data.py