For older versions of Microsoft Excel
For newer versions, read this
Estabilish a connection
host
: The hostname of the database you are connecting to (Default:localhost
)userS
: The MySQL user to authenticate aspasswordS
: The password of that MySQL userdatabaseS
: Name of the database to use for this connectionportS
: The port number to connect to
table
: The output table's name
query_count
: A count query to count the number of rows produced by the query (for the progress bar)
query
: The SQL query
To install dependencies
pip install requirements.txt
To run
python export.py