PyQt5学习笔记（一）

昨天主要调通了如何把EXCEL中的数据显示到QTableWidget里，其中主要用到xlrd类

代码如下：

self.excelfile = xlrd.open_workbook(r'xx.xls')
self.sheet1 = self.excelfile.sheet_by_index(0)

cols = self.sheet1.row_values(0)
rows = self.sheet1.col_values(1)
col_length = len(cols)-1
row_length = len(rows)
e = QTableWidget()
e.setColumnCount(col_length-2)
e.setHorizontalHeaderLabels(["接口类型", "所属模块", "接口名称","用例ID","用例名称","请求方式","请求地址URL","请求Header","请求包体","期望结果类型","期望结果","检查字段","传递字段","传递目标字段","检查数据库SQL","检查数据库结果","用例状态","操作人"])
headeritem = e.horizontalHeader()

interface = []
moudle_list = []
method_list = []
e.setSelectionBehavior(QAbstractItemView.SelectRows)
for row in range(1, row_length):
    e.insertRow(row-1)
    for col in range(0, col_length):
        e.setItem(row-1, col, QTableWidgetItem(self.sheet1.row_values(row)[col]))
        interface.append(self.sheet1.row_values(row)[0])
        moudle_list.append(self.sheet1.row_values(row)[1])
        method_list.append(self.sheet1.row_values(row)[5])