用lis加载Qtablewidget

Question

我有如下清单

[('John', datetime.datetime(2019, 5, 5, 0, 54), datetime.datetime(2019, 5, 26, 22, 51, 36)),
('Rex', datetime.datetime(2019, 5, 26, 22, 51, 36), datetime.datetime(2019, 6, 15, 10, 22, 48)),
('Watson', datetime.datetime(2019, 6, 15, 10, 22, 48), datetime.datetime(2019, 7, 8, 13, 33, 36)), 
('Manila', datetime.datetime(2019, 7, 8, 13, 33, 36), datetime.datetime(2019, 7, 29, 6, 18)), 
('Pete', datetime.datetime(2019, 7, 29, 6, 18), datetime.datetime(2019, 8, 6, 18, 50, 24)), 
('Mathew', datetime.datetime(2019, 8, 6, 18, 50, 24), datetime.datetime(2019, 8, 31, 3, 14, 24))]

我创建了一个如下所示的用户界面 Qtablewidget

如何在Name列中添加名称，From列中添加第一个日期，To列中添加第二个日期。我试过按一下按钮setitem，但没用

^{pr2}$

我该怎么做

Answer 1

基本上这就像是在使用二维阵列

• 获取数据的行数和列数：

  numcols = len(data[0])   # ( to get number of columns, count number of values in first row( first row is data[0]))
  
  numrows = len(data)   # (to get number of rows, count number of values(which are arrays) in data(2D array))
  

• 设置QTableWidget的维度：

  self.tableWidget.setColumnCount(numcols)
  
  self.tableWidget.setRowCount(numrows)
  

• 使用basic nasted for loop传递数据（2D数组）： 在每个步骤中，将数据（2D数组）中的值设置到QTableWidget中的相同位置：

  self.tableWidget.setItem(row, column, QTableWidgetItem((data[row][column])))
  

  其中：

  • 行，列=QTableWidget中的索引

  • QTableWidgetItem（（data[row][column]）=将在QTableWidget中设置的值

注意：QTableWidgetItem（const QString&text）

QTableWidgetItem类提供一个与QTableWidget类一起使用的项

注意：您不能将datetime传递到QTableWidgetItem中，因为您需要检查您试图设置到QTableWidget中的值是否为datetime，如果是，则需要将datetime转换为字符串：

if isinstance(data[row][column], datetime.datetime):

     ...data[row][column].strftime('%d/%m/%Y %H:%M:%S')

完整代码：

    from PyQt5.QtWidgets import QTableWidgetItem
    from datetime import datetime
    import datetime

    data = [('John', datetime.datetime(2019, 5, 5, 0, 54), datetime.datetime(2019, 5, 26, 22, 51, 36)),
    ('Rex', datetime.datetime(2019, 5, 26, 22, 51, 36), datetime.datetime(2019, 6, 15, 10, 22, 48)),
    ('Watson', datetime.datetime(2019, 6, 15, 10, 22, 48), datetime.datetime(2019, 7, 8, 13, 33, 36)),
    ('Manila', datetime.datetime(2019, 7, 8, 13, 33, 36), datetime.datetime(2019, 7, 29, 6, 18)),
    ('Pete', datetime.datetime(2019, 7, 29, 6, 18), datetime.datetime(2019, 8, 6, 18, 50, 24)),
    ('Mathew', datetime.datetime(2019, 8, 6, 18, 50, 24), datetime.datetime(2019, 8, 31, 3, 14, 24))]

    numrows = len(data)  # 6 rows in your example
    numcols = len(data[0])  # 3 columns in your example

    # Set colums and rows in QTableWidget
    self.tableWidget.setColumnCount(numcols)
    self.tableWidget.setRowCount(numrows)

    # Loops to add values into QTableWidget
    for row in range(numrows):
        for column in range(numcols):
            # Check if value datatime, if True convert to string 
            if isinstance(data[row][column], datetime.datetime):
                self.tableWidget.setItem(row, column, QTableWidgetItem((data[row][column].strftime('%d/%m/%Y %H:%M:%S'))))
            else:
                self.tableWidget.setItem(row, column, QTableWidgetItem((data[row][column])))

结果：