Scan MySQL db table into Excel table formate.
Nice tool for scan DB MySQL table into Excel table.
Technologies | Version |
---|---|
Python | 3.7.9 |
tkinter | 8.6 |
xlsxwriter | 1.3.6 |
All the project development has be done with
IntelliJ IDEA 2020.2.3 (Community Edition).
- Run connection_gui.py that generated ConnectionWindow
- Insert MySQL connection details: host, user, database name, password.
- Press connect button.
- If connected successfully, and querys_mysql.py done some important stuff, then
select table from SelectTableWindow. - Press Create Table button and write_excel_file.py will create the table in Excel.
- Select empty directory path to save the Excel files into.
- The selected directory path window will be open with the generated files.