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=xXDR9rxVfA8

Setup database table

products table structure

product_notes table structure

categories table structure

hashtags table structure

products_hashtags table structure

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