python pyqt5编写一个界面，能够导入excel数据，并对数据进行增删改查，高级

好的，我可以为您提供一份 Pyqt5 编写的 Excel 数据管理界面的代码，它可以实现导入 Excel 数据、增删改查和高级操作。请注意，以下代码仅供参考，您可以根据自己的需求进行修改和优化。

import sys
from PyQt5.QtWidgets import QApplication, QMainWindow, QFileDialog, QMessageBox, QTableWidgetItem
import openpyxl

class ExcelManager(QMainWindow):
    def __init__(self):
        super().__init__()
        self.initUI()

    def initUI(self):
        self.setWindowTitle('Excel数据管理')
        self.setGeometry(100, 100, 800, 600)

        self.tableWidget = QTableWidget(self)
        self.tableWidget.setGeometry(10, 10, 780, 520)

        menubar = self.menuBar()
        fileMenu = menubar.addMenu('文件')
        importAction = fileMenu.addAction('导入')
        importAction.triggered.connect(self.importExcel)

        editMenu = menubar.addMenu('编辑')
        addAction = editMenu.addAction('新增')
        addAction.triggered.connect(self.addRow)
        deleteAction = editMenu.addAction('删除')
        deleteAction.triggered.connect(self.deleteRow)
        modifyAction = editMenu.addAction('修改')
        modifyAction.triggered.connect(self.modifyRow)

        searchMenu = menubar.addMenu('查询')
        simpleSearchAction = searchMenu.addAction('简单查询')
        simpleSearchAction.triggered.connect(self.simpleSearch)
        advancedSearchAction = searchMenu.addAction('高级查询')
        advancedSearchAction.triggered.connect(self.advancedSearch)

    def importExcel(self):
        filePath, _ = QFileDialog.getOpenFileName(self, '选择文件', '', 'Excel文件 (*.xlsx)')
        if filePath:
            try:
                workbook = openpyxl.load_workbook(filePath)
                sheet = workbook.active
                self.tableWidget.setRowCount(sheet.max_row)
                self.tableWidget.setColumnCount(sheet.max_column)
                for i in range(1, sheet.max_row + 1):
                    for j in range(1, sheet.max_column + 1):
                        cell = sheet.cell(row=i, column=j)
                        item = QTableWidgetItem(str(cell.value))
                        self.tableWidget.setItem(i - 1, j - 1, item)
                self.tableWidget.setHorizontalHeaderLabels([sheet.cell(row=1, column=j).value for j in range(1, sheet.max_column + 1)])
            except Exception as e:
                QMessageBox.critical(self, '错误', str(e))

    def addRow(self):
        rowPosition = self.tableWidget.rowCount()
        self.tableWidget.insertRow(rowPosition)

    def deleteRow(self):
        selectedRows = set()
        for item in self.tableWidget.selectedItems():
            selectedRows.add(item.row())
        for i in reversed(sorted(selectedRows)):
            self.tableWidget.removeRow(i)

    def modifyRow(self):
        selectedItems = self.tableWidget.selectedItems()
        if len(selectedItems) != self.tableWidget.columnCount():
            QMessageBox.warning(self, '警告', '请选中一整行进行修改！')
            return
        row = selectedItems[0].row()
        items = []
        for i in range(self.tableWidget.columnCount()):
            item = self.tableWidget.item(row, i)
            items.append(item.text() if item else '')
        newItems, ok = ModifyDialog.modify(items)
        if ok:
            for i in range(self.tableWidget.columnCount()):
                item = QTableWidgetItem(newItems[i])
                self.tableWidget.setItem(row, i, item)

    def simpleSearch(self):
        searchText, ok = SearchDialog.search()
        if ok:
            for i in range(self.tableWidget.rowCount()):
                for j in range(self.tableWidget.columnCount()):
                    item = self.tableWidget.item(i, j)
                    if item and searchText in item.text():
                        self.tableWidget.selectRow(i)
                        break

    def advancedSearch(self):
        searchConditions, ok = SearchDialog.advancedSearch()
        if ok:
            for i in range(self.tableWidget.rowCount()):
                matched = True
                for condition in searchConditions:
                    col, op, value = condition
                    item = self.tableWidget.item(i, col)
                    if not item:
                        matched = False
                        break
                    itemText = item.text()
                    if op == '=' and itemText != value:
                        matched = False
                        break
                    elif op == 'like' and value not in itemText:
                        matched = False
                        break
                    elif op == '>' and float(itemText) <= float(value):
                        matched = False
                        break
                    elif op == '>=' and float(itemText) < float(value):
                        matched = False
                        break
                    elif op == '<' and float(itemText) >= float(value):
                        matched = False
                        break
                    elif op == '<=' and float(itemText) > float(value):
                        matched = False
                        break
                if matched:
                    self.tableWidget.selectRow(i)


class ModifyDialog(QMainWindow):
    def __init__(self, items):
        super().__init__()
        self.items = items
        self.initUI()

    def initUI(self):
        self.setWindowTitle('修改')
        self.setGeometry(300, 300, 400, 300)

        label1 = QLabel('第1列：', self)
        label1.move(10, 10)
        self.lineEdit1 = QLineEdit(self)
        self.lineEdit1.move(100, 10)
        self.lineEdit1.setText(self.items[0])
        label2 = QLabel('第2列：', self)
        label2.move(10, 50)
        self.lineEdit2 = QLineEdit(self)
        self.lineEdit2.move(100, 50)
        self.lineEdit2.setText(self.items[1])
        label3 = QLabel('第3列：', self)
        label3.move(10, 90)
        self.lineEdit3 = QLineEdit(self)
        self.lineEdit3.move(100, 90)
        self.lineEdit3.setText(self.items[2])
        label4 = QLabel('第4列：', self)
        label4.move(10, 130)
        self.lineEdit4 = QLineEdit(self)
        self.lineEdit4.move(100, 130)
        self.lineEdit4.setText(self.items[3])
        label5 = QLabel('第5列：', self)
        label5.move(10, 170)
        self.lineEdit5 = QLineEdit(self)
        self.lineEdit5.move(100, 170)
        self.lineEdit5.setText(self.items[4])

        okButton = QPushButton('确定', self)
        okButton.move(100, 220)
        okButton.clicked.connect(self.accept)
        cancelButton = QPushButton('取消', self)
        cancelButton.move(200, 220)
        cancelButton.clicked.connect(self.reject)

    @staticmethod
    def modify(items):
        dialog = ModifyDialog(items)
        result = dialog.exec_()
        newItems = [dialog.lineEdit1.text(), dialog.lineEdit2.text(), dialog.lineEdit3.text(), dialog.lineEdit4.text(), dialog.lineEdit5.text()]
        return newItems, result == QDialog.Accepted


class SearchDialog(QMainWindow):
    def __init__(self):
        super().__init__()
        self.initUI()

    def initUI(self):
        self.setWindowTitle('查询')
        self.setGeometry(300, 300, 300, 200)

        self.lineEdit = QLineEdit(self)
        self.lineEdit.setGeometry(10, 10, 200, 30)
        self.lineEdit.returnPressed.connect(self.accept)

        okButton = QPushButton('确定', self)
        okButton.setGeometry(10, 60, 80, 30)
        okButton.clicked.connect(self.accept)
        cancelButton = QPushButton('取消', self)
        cancelButton.setGeometry(100, 60, 80, 30)
        cancelButton.clicked.connect(self.reject)

    @staticmethod
    def search():
        dialog = SearchDialog()
        result = dialog.exec_()
        return dialog.lineEdit.text(), result == QDialog.Accepted

    @staticmethod
    def advancedSearch():
        dialog = AdvancedSearchDialog()
        result = dialog.exec_()
        return dialog.getSearchConditions(), result == QDialog.Accepted


class AdvancedSearchDialog(QMainWindow):
    def __init__(self):
        super().__init__()
        self.initUI()

    def initUI(self):
        self.setWindowTitle('高级查询')
        self.setGeometry(300, 300, 400, 300)

        self.tableWidget = QTableWidget(self)
        self.tableWidget.setGeometry(10, 10, 380, 200)
        self.tableWidget.setColumnCount(3)
        self.tableWidget.setHorizontalHeaderLabels(['列', '操作符', '值'])
        self.tableWidget.verticalHeader().setVisible(False)

        okButton = QPushButton('确定', self)
        okButton.move(100, 220)
        okButton.clicked.connect(self.accept)
        cancelButton = QPushButton('取消', self)
        cancelButton.move(200, 220)
        cancelButton.clicked.connect(self.reject)

    def getSearchConditions(self):
        searchConditions = []
        for i in range(self.tableWidget.rowCount()):
            col = self.tableWidget.item(i, 0).text()
            op = self.tableWidget.item(i, 1).text()
            value = self.tableWidget.item(i, 2).text()
            searchConditions.append((int(col), op, value))
        return searchConditions

    def addCondition(self):
        rowPosition = self.tableWidget.rowCount()
        self.tableWidget.insertRow(rowPosition)

    def deleteCondition(self):
        selectedRows = set()
        for item in self.tableWidget.selectedItems():
            selectedRows.add(item.row())
        for i in reversed(sorted(selectedRows)):
            self.tableWidget.removeRow(i)


if __name__ == '__main__':
    app = QApplication(sys.argv)
    excelManager = ExcelManager()
    excelManager.show()
    sys.exit(app.exec_())

这份代码实现了一个 Excel 数据管理界面，包括导入 Excel 数据、增删改查和高级操作。您可以通过菜单栏进行操作，具体实现方式请参考代码注释。如果您有任何问题或需要进一步优化，请随时与我联系。