如何在PyQt5的QTableWidget中复制和粘贴多个单元格?

3
我有一个如下所示的Qtablewidget。我想要复制表格中的多个单元格并将其粘贴到同一表格中的其他行中。
到目前为止,我只能对单个单元格执行相同操作,但是否有办法同时处理多个单元格?
如果可能的话,也可以将多个行复制并粘贴到同一表格中的下方吗?
我尝试在SO上查找答案,但是在PyQt5中实现起来有些困难。
提前感谢。

Snippet for Single Row Copy/Paste

Snippet for multiple Row Copy/Paste

示例代码(由QtDesigner提供):

from PyQt5 import QtCore, QtGui, QtWidgets


class Ui_MainWindow(object):
    def setupUi(self, MainWindow):
        MainWindow.setObjectName("MainWindow")
        MainWindow.resize(1048, 600)
        self.centralwidget = QtWidgets.QWidget(MainWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.tableWidget = QtWidgets.QTableWidget(self.centralwidget)
        self.tableWidget.setGeometry(QtCore.QRect(40, 40, 861, 511))
        self.tableWidget.setEditTriggers(QtWidgets.QAbstractItemView.AnyKeyPressed|QtWidgets.QAbstractItemView.DoubleClicked|QtWidgets.QAbstractItemView.EditKeyPressed)
        self.tableWidget.setRowCount(5)
        self.tableWidget.setColumnCount(5)
        self.tableWidget.setObjectName("tableWidget")
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setHorizontalHeaderItem(0, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setHorizontalHeaderItem(1, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setHorizontalHeaderItem(2, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setHorizontalHeaderItem(3, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setHorizontalHeaderItem(4, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(0, 0, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(0, 1, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(0, 2, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(0, 3, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(0, 4, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(1, 0, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(1, 1, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(1, 2, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(1, 3, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(1, 4, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(2, 0, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(2, 1, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(2, 2, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(2, 3, item)
        item = QtWidgets.QTableWidgetItem()
        self.tableWidget.setItem(2, 4, item)
        self.tableWidget.horizontalHeader().setVisible(True)
        self.tableWidget.verticalHeader().setVisible(False)
        MainWindow.setCentralWidget(self.centralwidget)
        self.statusbar = QtWidgets.QStatusBar(MainWindow)
        self.statusbar.setObjectName("statusbar")
        MainWindow.setStatusBar(self.statusbar)

        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)

    def retranslateUi(self, MainWindow):
        _translate = QtCore.QCoreApplication.translate
        MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
        item = self.tableWidget.horizontalHeaderItem(0)
        item.setText(_translate("MainWindow", "Name"))
        item = self.tableWidget.horizontalHeaderItem(1)
        item.setText(_translate("MainWindow", "ID"))
        item = self.tableWidget.horizontalHeaderItem(2)
        item.setText(_translate("MainWindow", "City"))
        item = self.tableWidget.horizontalHeaderItem(3)
        item.setText(_translate("MainWindow", "Number"))
        item = self.tableWidget.horizontalHeaderItem(4)
        item.setText(_translate("MainWindow", "Occupation"))
        __sortingEnabled = self.tableWidget.isSortingEnabled()
        self.tableWidget.setSortingEnabled(False)
        item = self.tableWidget.item(0, 0)
        item.setText(_translate("MainWindow", "Mark"))
        item = self.tableWidget.item(0, 1)
        item.setText(_translate("MainWindow", "1"))
        item = self.tableWidget.item(0, 2)
        item.setText(_translate("MainWindow", "Newyork"))
        item = self.tableWidget.item(0, 3)
        item.setText(_translate("MainWindow", "4796423643344"))
        item = self.tableWidget.item(0, 4)
        item.setText(_translate("MainWindow", "Teacher"))
        item = self.tableWidget.item(1, 0)
        item.setText(_translate("MainWindow", "Taylor"))
        item = self.tableWidget.item(1, 1)
        item.setText(_translate("MainWindow", "2"))
        item = self.tableWidget.item(1, 2)
        item.setText(_translate("MainWindow", "Chicago"))
        item = self.tableWidget.item(1, 3)
        item.setText(_translate("MainWindow", "43683284"))
        item = self.tableWidget.item(1, 4)
        item.setText(_translate("MainWindow", "Nurse"))
        self.tableWidget.setSortingEnabled(__sortingEnabled)


if __name__ == "__main__":
    import sys
    app = QtWidgets.QApplication(sys.argv)
    MainWindow = QtWidgets.QMainWindow()
    ui = Ui_MainWindow()
    ui.setupUi(MainWindow)
    MainWindow.show()
    sys.exit(app.exec_())

派生类:

from PyQt5 import QtWidgets

from demo import Ui_MainWindow

class demo_code(QtWidgets.QMainWindow, Ui_MainWindow):                    
    def __init__(self):
        super(demo_code, self).__init__()
        self.setupUi(self) 



if __name__ == "__main__":
    import sys
    app = QtWidgets.QApplication(sys.argv)
    window = demo_code()    
    window.show()
    sys.exit(app.exec_())

  1. 你说“我可以在单个单元格上做同样的事情”,如果你能展示一下就好了。
  2. 将要添加的行总是最后一行吗?
- eyllanesc
你说:“我认为单元格复制和粘贴是默认的”,你检查过它是否有效吗?你应该更加精确,而不是指出:“如果你还没有尝试,我可以在单个单元格上做同样的事情。” - eyllanesc
是的,我刚刚检查了将单个单元格复制并粘贴到其他单元格中,它有效! - Vi_py123
我指的是一个单元格而不是整行或多个单元格。这可以在输入表格中的值时完成。 - Vi_py123
@Vi_py123 这不是复制单元格,而是在编辑单元格时复制文本。 - musicamante
显示剩余2条评论
4个回答

6
这里提供一种解决方案:通过子类化QTableWidget类并重新实现keyPressEvent函数来捕获复制和粘贴的键序列。在复制时,使用QTableWidget.selectedIndexes()保存当前选定的项目。在粘贴时,为列表中的每个单元格设置一个新的QTableWidgetItem,并将索引转换为新的突出显示的索引。它会粘贴所有被强调的单元格,它们不需要在同一行中。它假定最小索引的单元格将被放置在粘贴到的突出显示的单元格中。
import sys
from PyQt5.QtWidgets import *
from PyQt5.QtCore import *

class Table(QTableWidget):

    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        self.setRowCount(10)
        self.setColumnCount(10)
        # etc.

    def keyPressEvent(self, event):
        super().keyPressEvent(event)
        if event.key() == Qt.Key_C and (event.modifiers() & Qt.ControlModifier):
            self.copied_cells = sorted(self.selectedIndexes())
        elif event.key() == Qt.Key_V and (event.modifiers() & Qt.ControlModifier):
            r = self.currentRow() - self.copied_cells[0].row()
            c = self.currentColumn() - self.copied_cells[0].column()
            for cell in self.copied_cells:
                self.setItem(cell.row() + r, cell.column() + c, QTableWidgetItem(cell.data()))

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

复制函数也适用于子类化 QTableView,没有检查粘贴功能。 - SiP

3

以下是针对 PyQt6 的解决方案,支持将 QTableWidget 中的多个单元格选择项复制到剪贴板,以便您可以将这些选择项粘贴到流行的电子表格程序中,如 Google Sheets、Apple Numbers 或 Microsoft Excel。这些程序期望使用制表符 ('\t') 作为新列的分隔符,并使用换行符 ('\n') 作为新行的分隔符。

from PyQt6.QtCore import *
from PyQt6.QtWidgets import *
from PyQt6.QtGui import *

import sys

class TableWithCopy(QTableWidget):
    """
    this class extends QTableWidget
    * supports copying multiple cell's text onto the clipboard
    * formatted specifically to work with multiple-cell paste into programs
      like google sheets, excel, or numbers
    """

    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)

    def keyPressEvent(self, event):
        super().keyPressEvent(event)
        if event.key() == Qt.Key.Key_C and (event.modifiers() & Qt.KeyboardModifier.ControlModifier):
            copied_cells = sorted(self.selectedIndexes())

            copy_text = ''
            max_column = copied_cells[-1].column()
            for c in copied_cells:
                copy_text += self.item(c.row(), c.column()).text()
                if c.column() == max_column:
                    copy_text += '\n'
                else:
                    copy_text += '\t'
                    
            QApplication.clipboard().setText(copy_text)

if __name__ == '__main__':
    app = QApplication(sys.argv)
    gui = TableWithCopy()
    gui.setColumnCount(10)
    gui.setRowCount(10)
    gui.show()
    sys.exit(app.exec())

0
稍微扩展一下boochbrain的答案,使用粘贴功能(在我的用例中,我需要数据覆盖所有行和列,以进行粘贴):
from PyQt6.QtCore import *
from PyQt6.QtWidgets import *
from PyQt6.QtGui import *

import sys

class TableWithCopy(QTableWidget):
    """
    this class extends QTableWidget
    * supports copying multiple cell's text onto the clipboard
    * formatted specifically to work with multiple-cell paste into programs
      like google sheets, excel, or numbers
    """

    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)

    def keyPressEvent(self, event):
        super().keyPressEvent(event)
        if event.key() == Qt.Key.Key_C and (event.modifiers() & Qt.KeyboardModifier.ControlModifier):
            copied_cells = sorted(self.selectedIndexes())

            copy_text = ''
            max_column = copied_cells[-1].column()
            for c in copied_cells:
                copy_text += self.item(c.row(), c.column()).text()
                if c.column() == max_column:
                    copy_text += '\n'
                else:
                    copy_text += '\t'
                    
            QApplication.clipboard().setText(copy_text)

        if event.key() == Qt.Key_V and (event.modifiers() & Qt.KeyboardModifier.ControlModifier):
            rows = QApplication.clipboard().text().split('\n')[:-1]
            if len(rows) == 0:
                return
            if len(rows) != self.rowCount() or len(rows[0].split('\t')) != self.columnCount():
                QMessageBox.information(None, 'Error', 'The pasted data does not contain the correct data')
                return
            self.clear()
            self.setRowCount(len(rows))
            self.setColumnCount(len(rows[0].split('\t')))
            for i, row in enumerate(rows):
                row = row.split('\t')
                item1 = QTableWidgetItem(row[0])
                item2 = QTableWidgetItem(row[1])
                self.setItem(i, 0, item1)
                self.setItem(i, 1, item2)

if __name__ == '__main__':
    app = QApplication(sys.argv)
    gui = TableWithCopy()
    gui.setColumnCount(10)
    gui.setRowCount(10)
    gui.show()
    sys.exit(app.exec())

0
def copy_selected_cells(self):
    copied_cells = sorted(self.ui.tableWidget.selectedIndexes())
    copy_text = ''
    max_column = copied_cells[-1].column()
    max_row = copied_cells[-1].row()
    for c in copied_cells:
        copy_text += self.ui.tableWidget.item(c.row(), c.column()).text()
        if c.column() == max_column:
            if c.row() != max_row:
                copy_text += '\n'
        else:
            copy_text += '\t'
    QApplication.clipboard().setText(copy_text)
def paste_to_cells(self):
    selection = self.ui.tableWidget.selectedIndexes()
    if selection:
        row_anchor = selection[0].row()
        column_anchor = selection[0].column()
        clipboard = QApplication.clipboard()
        rows = clipboard.text().split('\n')
        for indx_row, row in enumerate(rows):
            values = row.split('\t')
            for indx_col, value in enumerate(values):
                if row_anchor + indx_row < self.ui.tableWidget.rowCount() and column_anchor + indx_col < self.ui.tableWidget.columnCount():
                    item = QTableWidgetItem(value)
                    self.ui.tableWidget.setItem(row_anchor + indx_row, column_anchor + indx_col, item)

我使用上面的代码实现了复制和粘贴的方法。 如果 c.row() 不等于最大行数: copy_text += '\n' 我修复了一个类似于复制方法的错误。

网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接