xecel已编辑好,用QFileDialog控件的保存功能怎么建立信号与保存按键的联动
from PyQt5.Qt import *
import openpyxl
class Window(QWidget):
def __init__(self):
super().__init__()
self.setWindowTitle('保存问题')
self.resize(500,500)
self.setup_ui()
def setup_ui(self):
wb = openpyxl.load_workbook('The data.xlsx')
wb_sheet = wb.active
wb_sheet['E2'] = 22
save1 = QFileDialog(self, '选择保存位置', '../', 'All(*.*);;Excel(.xlsx)')
save1.setAcceptMode(QFileDialog.AcceptSave)
save1.setDefaultSuffix('xlsx')
save1.directoryEntered.connect()
save1.open()
wb.save(把修改好的wb保存到选择的路径下面(怎么建立保存按钮
和save1.directoryEntered.connect()直接的联动关系?))
if __name__ == '__main__':
import sys
app = QApplication(sys.argv)
window = Window()
window.show()
sys.exit(app.exec_())
```python
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file '111.ui'
#
# Created by: PyQt5 UI code generator 5.15.4
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again. Do not edit this file unless you know what you are doing.
import os
import openpyxl
from PyQt5 import QtCore, QtGui, QtWidgets
from PyQt5.QtWidgets import QApplication, QFileDialog
class Ui_Window(object):
def setupUi(self, Window):
Window.setObjectName("Window")
Window.resize(640, 480)
self.pushButton = QtWidgets.QPushButton(Window)
self.pushButton.setGeometry(QtCore.QRect(240, 230, 75, 23))
self.pushButton.setObjectName("pushButton")
self.retranslateUi(Window)
self.pushButton.clicked.connect(Window.cleck_sanlv)
QtCore.QMetaObject.connectSlotsByName(Window)
def retranslateUi(self, Window):
_translate = QtCore.QCoreApplication.translate
Window.setWindowTitle(_translate("Window", "Form"))
self.pushButton.setText(_translate("Window", "PushButton"))
class Main_tset(QtWidgets.QMainWindow, Ui_Window):
def __init__(self):
super(Main_tset, self).__init__()
self.setupUi(self)
self.cwd = os.getcwd() # 获取当前程序文件位置
def cleck_sanlv(self):
wb = openpyxl.load_workbook('The data.xlsx')
wb_sheet = wb.active
wb_sheet['E2'] = 22
self.cwd = os.getcwd() # 获取当前程序文件位置
dirpath, filetype = QFileDialog().getSaveFileName(self,
"文件保存",
self.cwd + '/表.xls', # 起始路径
"xls(*.xls);;Text(*.txt);;All Files (*)")
if dirpath == "":
print("\n取消选择")
return
wb.save(dirpath)
if __name__ == '__main__':
import sys
app = QApplication(sys.argv)
Window = Main_tset()
Window.show()
sys.exit(app.exec_())
```