[TOC]
Recommond virtualenv or conda to manage your pakage.
These tools just for researcher to imporve efficiency.
Please do not use it for commercial purposes.
python3.9
windows 10 x64
virtualenv -p python3.9 venv # create environment
# windows10 activate
.\venv\Scripts\activate.ps1
# macos/linux activate
source .\venv\bin\activate
# install
pip install -r .\requirements.txtTransfer the excell files, xlsx, to mysql database
pip install -r requirements.txt
config.toml
# 使用前务必确认配置正确，并提前创建好mysql数据库
# Make sure that the configuration is correct and the MySQL database is created in advance.
[database]
# 默认使用sqlite3作为本地数据库，可以选择其他数据库mysql(已测试)等
name = "sqlite3"
[mysql]
host = "47.110.114.146"
user = "root"
password = "pwd"
port = 3306
database = "db"
[mysql.parameters]
pool_size = 5
charset = "utf-8"python transfer_complicate.py 'yourfilename.xlsx'├─example
├─photo
├─readmodule
└─writemodule
└─db
└─Complextable