我想在PyQt5的QtableView中显示一个csv文件

Question

我在QtDesigner上设计了GUI的布局，并将其转换为python文件。我已经搜索了现有的问题以寻找解决方案，但要么我错过了，要么没有。我想在GUI的表格视图上显示我的csv文件。

从PyQt5导入QtCore、QtGui、QtWidgets导入csv

class Ui_MainWindow(object):

#def __init__(self, parent=None):
#self.model = QtGui.QStandardItemModel(self)

def setupUi(self, MainWindow):
MainWindow.setObjectName("MainWindow")
MainWindow.resize(800, 600)
self.centralwidget = QtWidgets.QWidget(MainWindow)
self.centralwidget.setObjectName("centralwidget")
self.tableView = QtWidgets.QTableView(self.centralwidget)
self.tableView.setGeometry(QtCore.QRect(15, 21, 761, 361))
self.tableView.setObjectName("tableView")
#self.tableView.setModel(self.model)
self.tableView.horizontalHeader().setStretchLastSection(True)
self.pushButton = QtWidgets.QPushButton(self.centralwidget)
self.pushButton.setGeometry(QtCore.QRect(80, 430, 161, 61))
self.pushButton.setObjectName("pushButton")
self.pushButton_2 = QtWidgets.QPushButton(self.centralwidget)
self.pushButton_2.setGeometry(QtCore.QRect(550, 420, 141, 81))
self.pushButton_2.setObjectName("pushButton_2")
MainWindow.setCentralWidget(self.centralwidget)
self.menubar = QtWidgets.QMenuBar(MainWindow)
self.menubar.setGeometry(QtCore.QRect(0, 0, 800, 21))
self.menubar.setObjectName("menubar")
MainWindow.setMenuBar(self.menubar)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)

self.pushButton.clicked.connect(self.loadCsv)
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.pushButton.setText(_translate("MainWindow", "PushButton"))
self.pushButton_2.setText(_translate("MainWindow", "PushButton"))


def loadCsv(self):
fileName = 'C:/Users/Rada1/Desktop/data.csv'
with open(fileName, "r") as fileInput:
for row in csv.reader(fileInput):    
items = [
QtGui.QStandardItem(field)
for field in row
]
self.model.appendRow(items)


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_())

当我运行此代码时，我得到错误

AttributeError: 'Ui_MainWindow' object has no attribute 'model'

然后，我尝试将self.model = QtGui.QStandardItemModel(self)初始化为Ui_MainWindow类，但却得到了错误

TypeError: arguments did not match any overloaded call:
QStandardItemModel(parent: QObject = None): argument 1 has unexpected type 'Ui_MainWindow'
QStandardItemModel(int, int, parent: QObject = None): argument 1 has unexpected type 'Ui_MainWindow'

我该如何让它发挥作用？

Answer 1

错误是明确的：QtGui.QStandardItemModel(parent)需要QObject作为parent；你给它一个object。

例如，您可以在setupUi:中添加这两行

self.model = QtGui.QStandardItemModel(MainWindow)
self.tableView.setModel(self.model)