PySide6读取EXCLE文档

https://www.jb51.net/article/164615.htm 课外URL

http://darrending.com/2016/07/11/qt%E8%AE%BE%E8%AE%A1%E5%8F%AF%E8%87%AA%E9%80%82%E5%BA%94%E7%9A%84%E7%94%A8%E6%88%B7%E7%95%8C%E9%9D%A2%EF%BC%88qt-designer%E7%AF%87%EF%BC%89/

https://www.jb51.net/article/167015.htm

课外URL

 

1、新建一个run.py(要运行的文件),代码如下

# -*- coding: utf-8 -*-
"""
文件名称:  run.py
文件创建时间:  2021/8/10 11:08
软件名称:   PyCharm
文件作者:  黄氏
"""
import sys

from PySide6 import QtCore
from PySide6.QtWidgets import QApplication
import pandas as mypd

# 导入所画的界面
from  tabledemo import *

# 自定义类
class Excel_Table(QMainWindow, Ui_MainWindow):
    def __init__(self):
        super().__init__()
        self.setupUi(self)

        self.excelButton.clicked.connect(self.Open_Excel_File) # connect作用就是执行某个函数
        self.saveButton.clicked.connect(self.Excel_Save)

    def Open_Excel_File(self):
        excel_name = QFileDialog.getOpenFileName(self, '选择文件', '', 'Excel files(*.xlsx)')   # 过滤出xlsx格式的文件
        self.path_excel_name = excel_name[0]
        print("Excel文档的路径: ", self.path_excel_name)
        if len(self.path_excel_name) > 0:
            self.Read_Excel_Data()
            self.Table_Initialize()

    # 读取 EXCEL 文档的数据
    def Read_Excel_Data(self):
        self.excel_file = mypd.read_excel(self.path_excel_name)
        # 获取数据的行标签与列标签
        self.columns = self.excel_file.columns
        self.rows = self.excel_file.index

    # 定义表格的初始化参数
    def Table_Initialize(self):
        self.tableWidget.setHorizontalScrollBarPolicy(QtCore.Qt.ScrollBarAlwaysOn)
        self.tableWidget.setRowCount(len(self.rows))    # 设置表格的行数
        self.tableWidget.setColumnCount(len(self.columns))  # 设置表格的列数
        self.tableWidget.setHorizontalHeaderLabels(self.columns) # 设置表格的列标签
        self.tableWidget.setGeometry(QtCore.QRect(223,120,1000,800)) # 重新设置表格区域的大小
        # 将 EXCEL 文档的数据显示在表格中
        for i in range(len(self.rows)):
            for j in range(len(self.columns)):
                tstr = str(self.excel_file.iloc[i][j])
                data = QTableWidgetItem(tstr)
                self.tableWidget.setItem(i, j, data)

        self.tableWidget.resizeColumnsToContents() # 列宽随着内容调整
        self.tableWidget.resizeRowsToContents() # 行宽随着内容调整
        self.tableWidget.setAlternatingRowColors(True)  # 表格的颜色交错显示
        self.tableWidget.itemChanged.connect(self.Table_Data_Change) # 将表格中单元格改变时,触发 Table_Data_Change 事件

    # 当表格的内容改变时获取内容
    def Table_Data_Change(self,item):
        text = item.text()
        itemrow = item.row()
        itemcol = item.column()
        self.excel_file.iloc[itemrow,itemcol] = text # 使用[i][j]形式会报销
def Excel_Save(self): self.excel_file.to_excel(self.path_excel_name, index=False) if __name__ == '__main__': app = QApplication(sys.argv) excelTable = Excel_Table() excelTable.show() sys.exit(app.exec())

2、新建一个ui的python文档,文件 tabledemo.py 代码如下(我是用QtDesigner设计,通过PyUIC命令转换过来的)

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

################################################################################
## Form generated from reading UI file 'tabledemo.ui'
##
## Created by: Qt User Interface Compiler version 6.1.2
##
## WARNING! All changes made in this file will be lost when recompiling UI file!
################################################################################

from PySide6.QtCore import *  # type: ignore
from PySide6.QtGui import *  # type: ignore
from PySide6.QtWidgets import *  # type: ignore


class Ui_MainWindow(object):
    def setupUi(self, MainWindow):
        if not MainWindow.objectName():
            MainWindow.setObjectName(u"MainWindow")
        MainWindow.resize(918, 538)
        sizePolicy = QSizePolicy(QSizePolicy.Preferred, QSizePolicy.Preferred)
        sizePolicy.setHorizontalStretch(0)
        sizePolicy.setVerticalStretch(0)
        sizePolicy.setHeightForWidth(MainWindow.sizePolicy().hasHeightForWidth())
        MainWindow.setSizePolicy(sizePolicy)
        MainWindow.setLayoutDirection(Qt.LeftToRight)
        self.centralwidget = QWidget(MainWindow)
        self.centralwidget.setObjectName(u"centralwidget")
        self.formLayout = QFormLayout(self.centralwidget)
        self.formLayout.setObjectName(u"formLayout")
        self.horizontalLayout = QHBoxLayout()
        self.horizontalLayout.setObjectName(u"horizontalLayout")
        self.excelButton = QPushButton(self.centralwidget)
        self.excelButton.setObjectName(u"excelButton")

        self.horizontalLayout.addWidget(self.excelButton)

        self.horizontalSpacer = QSpacerItem(808, 17, QSizePolicy.Expanding, QSizePolicy.Minimum)

        self.horizontalLayout.addItem(self.horizontalSpacer)


        self.formLayout.setLayout(0, QFormLayout.LabelRole, self.horizontalLayout)

        self.horizontalLayout_2 = QHBoxLayout()
        self.horizontalLayout_2.setObjectName(u"horizontalLayout_2")
        self.horizontalSpacer_2 = QSpacerItem(828, 18, QSizePolicy.Expanding, QSizePolicy.Minimum)

        self.horizontalLayout_2.addItem(self.horizontalSpacer_2)

        self.saveButton = QPushButton(self.centralwidget)
        self.saveButton.setObjectName(u"saveButton")
        sizePolicy1 = QSizePolicy(QSizePolicy.Fixed, QSizePolicy.Fixed)
        sizePolicy1.setHorizontalStretch(0)
        sizePolicy1.setVerticalStretch(0)
        sizePolicy1.setHeightForWidth(self.saveButton.sizePolicy().hasHeightForWidth())
        self.saveButton.setSizePolicy(sizePolicy1)
        self.saveButton.setContextMenuPolicy(Qt.DefaultContextMenu)
        self.saveButton.setLayoutDirection(Qt.LeftToRight)

        self.horizontalLayout_2.addWidget(self.saveButton)


        self.formLayout.setLayout(2, QFormLayout.LabelRole, self.horizontalLayout_2)

        self.tableWidget = QTableWidget(self.centralwidget)
        self.tableWidget.setObjectName(u"tableWidget")
        self.tableWidget.setSizeAdjustPolicy(QAbstractScrollArea.AdjustToContents)

        self.formLayout.setWidget(1, QFormLayout.SpanningRole, self.tableWidget)

        MainWindow.setCentralWidget(self.centralwidget)
        self.menubar = QMenuBar(MainWindow)
        self.menubar.setObjectName(u"menubar")
        self.menubar.setGeometry(QRect(0, 0, 918, 22))
        MainWindow.setMenuBar(self.menubar)
        self.statusbar = QStatusBar(MainWindow)
        self.statusbar.setObjectName(u"statusbar")
        MainWindow.setStatusBar(self.statusbar)

        self.retranslateUi(MainWindow)

        QMetaObject.connectSlotsByName(MainWindow)
    # setupUi

    def retranslateUi(self, MainWindow):
        MainWindow.setWindowTitle(QCoreApplication.translate("MainWindow", u"MainWindow", None))
        self.excelButton.setText(QCoreApplication.translate("MainWindow", u"\u6253\u5f00Excel", None))
        self.saveButton.setText(QCoreApplication.translate("MainWindow", u"\u4fdd \u5b58", None))
    # retranslateUi

 

posted @ 2021-08-11 16:53  字符蹚浑水  阅读(856)  评论(0编辑  收藏  举报