pyqt5根据excel表生成表格控件

可以使用以下步骤根据 Excel 表生成表格控件：

1. 安装 pyqt5 和 openpyxl 库

pip install pyqt5 openpyxl

2. 导入所需的库

from PyQt5.QtWidgets import QApplication, QTableWidget, QTableWidgetItem
from openpyxl import load_workbook

3. 加载 Excel 表格

wb = load_workbook('example.xlsx')
sheet = wb.active

4. 创建表格控件

table = QTableWidget()
table.setRowCount(sheet.max_row)  # 设置行数
table.setColumnCount(sheet.max_column)  # 设置列数

5. 填充表格控件

for row in range(1, sheet.max_row+1):
    for col in range(1, sheet.max_column+1):
        value = sheet.cell(row=row, column=col).value
        item = QTableWidgetItem(str(value))
        table.setItem(row-1, col-1, item)

6. 显示表格控件

table.show()

完整示例代码如下：

from PyQt5.QtWidgets import QApplication, QTableWidget, QTableWidgetItem
from openpyxl import load_workbook

if __name__ == '__main__':
    app = QApplication([])
    wb = load_workbook('example.xlsx')
    sheet = wb.active
    table = QTableWidget()
    table.setRowCount(sheet.max_row)
    table.setColumnCount(sheet.max_column)
    for row in range(1, sheet.max_row+1):
        for col in range(1, sheet.max_column+1):
            value = sheet.cell(row=row, column=col).value
            item = QTableWidgetItem(str(value))
            table.setItem(row-1, col-1, item)
    table.show()
    app.exec_()