PySide6：QTableWidget与Excel间多单元格复制粘贴方案咨询

核心实现逻辑 #

通过重写QTableWidget的键盘事件处理，实现双向兼容Excel的复制粘贴：

• 按下Ctrl+C时，将选中区域的内容按制表符分隔列、换行分隔行的格式存入剪贴板（Excel原生支持该格式）
• 按下Ctrl+V时，读取剪贴板文本并拆分，对应写入表格，自动新增行列以适配粘贴内容

完整适配代码 #

from PySide6.QtWidgets import QApplication, QTableWidget, QTableWidgetItem, QMainWindow
from PySide6.QtCore import Qt, QMimeData
from PySide6.QtGui import QKeyEvent

class CustomTableWidget(QTableWidget):
    def keyPressEvent(self, event: QKeyEvent):
        # 处理Ctrl+C复制
        if event.matches(QKeyEvent.Copy):
            self.copy_selection()
            event.accept()
            return
        # 处理Ctrl+V粘贴
        elif event.matches(QKeyEvent.Paste):
            self.paste_from_clipboard()
            event.accept()
            return
        # 其他事件交给父类处理
        super().keyPressEvent(event)

    def copy_selection(self):
        selected_indexes = self.selectedIndexes()
        if not selected_indexes:
            return
        
        # 确定选中区域的边界
        rows = sorted(set(idx.row() for idx in selected_indexes))
        cols = sorted(set(idx.column() for idx in selected_indexes))
        min_row, max_row = rows[0], rows[-1]
        min_col, max_col = cols[0], cols[-1]

        # 构建Excel可识别的文本格式
        content = []
        for row in range(min_row, max_row + 1):
            row_content = []
            for col in range(min_col, max_col + 1):
                item = self.item(row, col)
                row_content.append(item.text() if item else "")
            content.append("\t".join(row_content))
        
        # 写入剪贴板
        clipboard = QApplication.clipboard()
        mime_data = QMimeData()
        mime_data.setText("\n".join(content))
        clipboard.setMimeData(mime_data)

    def paste_from_clipboard(self):
        clipboard = QApplication.clipboard()
        mime_data = clipboard.mimeData()
        if not mime_data.hasText():
            return
        
        # 解析剪贴板内容，过滤空行
        raw_text = mime_data.text()
        rows_data = [row for row in raw_text.split("\n") if row.strip()]
        if not rows_data:
            return
        
        # 获取粘贴起始位置
        selected_indexes = self.selectedIndexes()
        start_row, start_col = (selected_indexes[0].row(), selected_indexes[0].column()) if selected_indexes else (0, 0)

        # 逐行逐列写入表格
        for row_offset, row_str in enumerate(rows_data):
            cols_data = row_str.split("\t")
            current_row = start_row + row_offset
            # 自动新增行
            if current_row >= self.rowCount():
                self.insertRow(current_row)
            for col_offset, col_str in enumerate(cols_data):
                current_col = start_col + col_offset
                # 自动新增列
                if current_col >= self.columnCount():
                    self.insertColumn(current_col)
                # 设置单元格内容
                self.setItem(current_row, current_col, QTableWidgetItem(col_str))

# 测试示例
if __name__ == "__main__":
    import sys
    app = QApplication(sys.argv)
    main_win = QMainWindow()
    table = CustomTableWidget(5, 5)
    # 填充测试数据
    for i in range(5):
        for j in range(5):
            table.setItem(i, j, QTableWidgetItem(f"单元格 {i+1}-{j+1}"))
    main_win.setCentralWidget(table)
    main_win.resize(600, 400)
    main_win.show()
    sys.exit(app.exec())

与PyQt5方案的关键差异适配 #

1. 模块导入：将PyQt5的模块路径替换为PySide6对应模块
2. 类型注解：PySide6对类型提示兼容性更好，代码中保留了事件参数的类型注解（可按需省略）
3. 核心逻辑：事件匹配、剪贴板操作、单元格读写等核心逻辑在PySide6与PyQt5中完全一致，无需修改

内容的提问来源于stack exchange，提问作者ROB