from PyQt5 import QtWidgets
from PyQt5.QtWidgets import QFileDialog, QWidget
import json, xlwt
import pymysql
import pandas as pd
class MyWindow(QWidget):
def __init__(self):
super(MyWindow, self).__init__()
self.myButton = QtWidgets.QPushButton(self)
self.myButton.setObjectName("btn")
self.myButton.setText("按钮")
self.myButton.clicked.connect(self.save_xls)
def save_xls(self):
conn = pymysql.connect(host="127.0.0.1", port=3306, user="root", password="anywhere",
database="qt_students", charset="utf8")
df = pd.read_sql("""
select * from admin
""", con=conn) # 这带sql语句可以自己定制查询条件,然后在导出要使用的数据
xlwt.Workbook(encoding='utf-8', style_compression=0)
filepath, type = QFileDialog.getSaveFileName(self, '文件保存', '/', 'xls(*.xls)')
df.to_excel(filepath, index=False)
if __name__ == "__main__":
import sys
app = QtWidgets.QApplication(sys.argv)
myshow = MyWindow()
myshow.show()
sys.exit(app.exec_())
将mysql中的数据导入到电脑中自由选择的路径中(python)
最新推荐文章于 2024-05-25 20:32:51 发布