Skip to content

⭐Use this tool to help you import or outport your data between the databases and Excel

Notifications You must be signed in to change notification settings

lainso/Excel-DataBase-Converter

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Excel-Database-Converter

⭐This is a program for export/import a Excel file to the database.
⭐Test environment: MS Office 2019 Home And Student + Mysql 8.0.28, it works well.
⭐The program is based on Python, it uses the sqlalchemy, MySQLdb, pandas and PySide2.
⭐This the first time I try to upload a programs, if this helps you and you like it, click the stars and I will appreciate it.

How to use:

⭐Download the releases pack and unzip it, find the 'Converter.exe' and run it directly. You can run it without installing any other software in this way.
⭐Download all the files and open it in a IDE like Pycharm, run the 'main.py' so that you can see the window out.If you need an English version, please download 'main-en.ui', rename it as 'main.ui' and replace the original file.

Excel 数据库 导入导出工具

⭐这是一个用于导入/导出 Excel 文件的程序
⭐测试环境:微软Office 2019 + Mysql 8.0 28
⭐项目基于Python以及一些关于数据库操作的第三方库
⭐如果喜欢我的项目的话,就给个小星星吧~

使用方法:

⭐下载发布版本(在右边的Releases那里),解压后在文件夹里面找到 Converter.exe ,直接打开它就好啦。
⭐下载全部代码文件,用python的编译器打开 main.py ,然后编译运行也可以哦。