[PyQt5]打开Excel、CSV，tableWidget转换为dataframe，listWidget添加选项，for循环列表推导式--list/dict

Kara_YYDS

已于 2023-10-30 18:17:46 修改

阅读量748

点赞数

分类专栏：随笔文章标签： python list pyqt

于 2023-10-25 16:58:47 首次发布

本文链接：https://blog.youkuaiyun.com/Kara_YYDS/article/details/134038796

版权

文章介绍了如何使用PyQt5创建一个UI，实现打开Excel和CSV文件，将数据加载到TableWidget和QListWidget，并提供将TableWidget转换为pandasDataFrame的功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

untitled.py

# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file 'untitled.ui'
#
# Created by: PyQt5 UI code generator 5.15.9
#
# WARNING: Any manual changes made to this file will be lost when pyuic5 is
# run again.  Do not edit this file unless you know what you are doing.


from PyQt5 import QtCore, QtGui, QtWidgets


class Ui_Form(object):
    def setupUi(self, Form):
        Form.setObjectName("Form")
        Form.resize(640, 480)
        self.verticalLayout_3 = QtWidgets.QVBoxLayout(Form)
        self.verticalLayout_3.setObjectName("verticalLayout_3")
        self.horizontalLayout_2 = QtWidgets.QHBoxLayout()
        self.horizontalLayout_2.setObjectName("horizontalLayout_2")
        self.pushButton_excel = QtWidgets.QPushButton(Form)
        self.pushButton_excel.setObjectName("pushButton_excel")
        self.horizontalLayout_2.addWidget(self.pushButton_excel)
        self.pushButton_csv = QtWidgets.QPushButton(Form)
        self.pushButton_csv.setObjectName("pushButton_csv")
        self.horizontalLayout_2.addWidget(self.pushButton_csv)
        self.verticalLayout_3.addLayout(self.horizontalLayout_2)
        self.horizontalLayout = QtWidgets.QHBoxLayout()
        self.horizontalLayout.setObjectName("horizontalLayout")
        self.verticalLayout_2 = QtWidgets.QVBoxLayout()
        self.verticalLayout_2.setObjectName("verticalLayout_2")
        self.tableWidget = QtWidgets.QTableWidget(Form)
        self.tableWidget.setObjectName("tableWidget")
        self.tableWidget.setColumnCount(0)
        self.tableWidget.setRowCount(0)
        self.verticalLayout_2.addWidget(self.tableWidget)
        self.pushButton_tW2df = QtWidgets.QPushButton(Form)
        self.pushButton_tW2df.setObjectName("pushButton_tW2df")
        self.verticalLayout_2.addWidget(self.pushButton_tW2df)
        self.horizontalLayout.addLayout(self.verticalLayout_2)
        self.verticalLayout = QtWidgets.QVB