devbox
Li_阴宅
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

使用Python开发桌面应用程序

作者：Li_阴宅 | 2024-07-24 00:36:49

赞

踩

python开发桌面应用

前言

在本教程中，我们将使用Python编写一个功能强大的桌面应用程序，用于数据清洗、压缩、合并excel文件。该程序基于PySide6库和其他辅助库进行开发，提供了直观的用户界面和易于使用的功能。下面我们将对代码进行分块介绍。（底部附项目完整代码）

导入所需库和模块

在程序的开头，我们导入了各种必要的库和模块，包括在数据处理中使用的bag模块、图形界面相关的PySide6库、文件处理相关的zipfile、xlsxwriter和openpyxl，以及其他辅助库

创建数据清洗类（DataCleaning）

DataCleaning类是我们应用程序的核心组件之一，用于实现数据清洗功能。它包含了选择文件、保存文件、开始清洗和清洗附加选项等功能。具体而言，该类包括以下方法：

  • select_file：用于选择要清洗的文件
  • save_file：用于选择保存清洗结果的文件
  • run：开始执行数据清洗操作，根据用户选择的附加选项进行不同的清洗动

创建压缩、解压类（CompressionDecompression）

CompressionDecompression类用于实现文件压缩和解压功能。它包括选择文件、保存文件、压缩文件和解压文件等方法。具体而言，该类包括以下方法：

  • select_file：用于选择要压缩或解压的文件
  • save_file_1：用于选择保存压缩或解压结果的文件
  • on_button_clicked：用于执行解压文件操作
  • on_button_clicked1：用于执行压缩文件操作

创建合并表格类（SelectDirectory）

SelectDirectory类实现了合并表格的功能。它包括选择文件夹、选择保存文件和运行合并操作等方法。具体而言，该类包括以下方法：

  • choose_folder：用于选择要合并的表格文件所在的文件夹
  • save_file_1：用于选择保存合并结果的文件
  • run：执行合并表格操作

创建主布局类（Layout）

Layout类是整个应用程序的主布局类，用于显示各个功能的按钮和界面。它包含了数据清洗、压缩、合并和关键词抽取四个子界面，并提供了切换子界面的功能

程序入口

在程序的最后，我们创建了一个QApplication对象，实例化了Layout类，并显示应用程序的主窗口。

通过以上分块介绍，我们已经了解了整个应用程序的结构和各个功能的实现方式

功能图示

完整代码

  1. #!/usr/bin/env python3
  2. # coding:utf-8
  3. import re
  4. import sys
  5. import time
  6. import os
  7. from datetime import datetime
  8. import bag
  9. from PySide6.QtGui import QFont, QPainter, QPen, QPalette, QColor, QIntValidator
  10. from PySide6.QtWidgets import QApplication, QMainWindow, QLabel, QPushButton, QFrame, QFileDialog, QLineEdit, \
  11.     QProgressBar, QMessageBox, QStackedWidget, QVBoxLayout, QTextBrowser
  12. from PySide6.QtCore import Qt, QJsonDocument
  13. from tqdm import tqdm
  14. import zipfile
  15. import xlsxwriter
  16. import openpyxl
  17. import emoji
  18. import json
  19.  
  20.  
  21. session = bag.session.create_session()
  22.  
  23.  
  24. def judge(file_path):  # 加载数据
  25.     try:
  26.         suffix = file_path.split('.')[-1]
  27.         suffix_dic = {'xlsx': bag.Bag.read_excel, 'csv': bag.Bag.read_csv, 'json': bag.Bag.read_json}
  28.         data = suffix_dic.get(suffix)(file_path)
  29.         return data
  30.     except AttributeError:
  31.         print('未选择文件')
  32.         exit()
  33.  
  34.  
  35. def set_text_browser_background_color(text_browser, color):  # 设置背景颜色
  36.     palette = text_browser.palette()
  37.     palette.setColor(QPalette.Base, color)
  38.     text_browser.setPalette(palette)
  39.  
  40.  
  41. def set_text_browser_foreground_color(text_browser, color):   # 设置字体颜色
  42.     palette = text_browser.palette()
  43.     palette.setColor(QPalette.Text, color)
  44.     text_browser.setPalette(palette)
  45.  
  46.  
  47. def unzip_file(zip_path, extract_path):
  48.     with zipfile.ZipFile(zip_path, 'r') as zip_ref:
  49.         zip_ref.extractall(extract_path)
  50.  
  51.  
  52. # noinspection PyTypeChecker
  53. class SeparatorLine(QFrame):
  54.     def paintEvent(self, event):
  55.         painter = QPainter(self)
  56.         painter.setPen(QPen(self.palette().color(QPalette.Dark).darker(150), 2))
  57.         painter.drawLine(self.width() / 2, 0, self.width() / 2, self.height())
  58.  
  59.  
  60. # noinspection PyTypeChecker
  61. class SeparatorLine1(QFrame):
  62.     def paintEvent(self, event):
  63.         painter = QPainter(self)
  64.         painter.setPen(QPen(self.palette().color(QPalette.Dark).darker(150), 2))
  65.         painter.drawLine(0, self.height() / 2, self.width(), self.height() / 2)
  66.  
  67.  
  68. class Layout(QMainWindow):
  69.     def __init__(self):
  70.         super().__init__()
  71.  
  72.         self.data_cleaning = None
  73.         self.Compression = None
  74.         self.file_directory = None
  75.         self.keywords = None
  76.         self.ppt_order = None
  77.  
  78.         # 定义标题与窗口大小
  79.         self.setWindowTitle("数据清洗")
  80.         self.setGeometry(100, 100, 1280, 720)
  81.  
  82.         self.stacked_widget = QStackedWidget(self)
  83.         self.setCentralWidget(self.stacked_widget)
  84.  
  85.         self.label = QLabel(datetime.now().strftime("%Y-%m-%d"), self)
  86.         self.label.setGeometry(10, 5, 130, 50)
  87.         self.label.setFont(QFont("等线", 18))  # 设置字体和字号
  88.  
  89.         self.clean_data = QPushButton('数据清洗', self)
  90.         self.clean_data.setFont(QFont('等线', 11))
  91.         self.clean_data.setGeometry(155, 10, 130, 30)
  92.         self.clean_data.clicked.connect(self.show_data_cleaning)
  93.  
  94.         self.zip_data = QPushButton('压缩/解压', self)
  95.         self.zip_data.setFont(QFont('等线', 11))
  96.         self.zip_data.setGeometry(300, 10, 130, 30)
  97.         self.zip_data.clicked.connect(self.show_zip_page)
  98.  
  99.         self.zip_data = QPushButton('合并excel', self)
  100.         self.zip_data.setFont(QFont('等线', 11))
  101.         self.zip_data.setGeometry(445, 10, 130, 30)
  102.         self.zip_data.clicked.connect(self.select_directory)
  103.  
  104.         self.line = SeparatorLine(self)
  105.         self.line.setGeometry(150, 0, 2, 10000)  # 添加垂直分割线
  106.  
  107.         self.line_horizontal = SeparatorLine1(self)
  108.         # noinspection PyTypeChecker
  109.         self.line_horizontal.setGeometry(150, self.height() / 8, 10000, 2)  # 添加水平分割线
  110.  
  111.     def show_data_cleaning(self):
  112.         if not self.data_cleaning:
  113.             self.data_cleaning = DataCleaning()
  114.         self.stacked_widget.addWidget(self.data_cleaning)
  115.         self.stacked_widget.setCurrentWidget(self.data_cleaning)
  116.  
  117.     def show_zip_page(self):
  118.         if not self.Compression:
  119.             self.Compression = CompressionDecompression()
  120.         self.stacked_widget.addWidget(self.Compression)
  121.         self.stacked_widget.setCurrentWidget(self.Compression)
  122.  
  123.     def select_directory(self):
  124.         if not self.file_directory:
  125.             self.file_directory = SelectDirectory()
  126.         self.stacked_widget.addWidget(self.file_directory)
  127.         self.stacked_widget.setCurrentWidget(self.file_directory)
  128.  
  129.  
  130. # 清洗
  131. class DataCleaning(Layout):
  132.     def __init__(self):
  133.         super().__init__()
  134.         self.save_path = None
  135.         self.file_path = None
  136.         self.layout = QVBoxLayout()
  137.  
  138.         self.progress_bar = QProgressBar(self)
  139.         self.progress_bar.setGeometry(155, 235, 668, 28)
  140.         self.progress_bar.setVisible(False)
  141.  
  142.         self.button_select = QPushButton("打开", self)
  143.         self.button_select.setFont(QFont('等线', 11))
  144.         self.button_select.setGeometry(10, 60, 130, 30)
  145.         self.button_select.clicked.connect(self.select_file)
  146.  
  147.         self.button_save = QPushButton("另存为", self)
  148.         self.button_save.setFont(QFont('等线', 11))
  149.         self.button_save.setGeometry(10, 95, 130, 30)
  150.         self.button_save.clicked.connect(self.save_file)
  151.  
  152.         self.button_run = QPushButton("开始清洗", self)
  153.         self.button_run.setFont(QFont('等线', 11))
  154.         self.button_run.setGeometry(10, 130, 130, 30)
  155.         self.button_run.clicked.connect(self.run)
  156.  
  157.         self.button = QPushButton("清洗附加选项", self)
  158.         self.button.setFont(QFont('等线', 11))
  159.         self.button.setGeometry(155, 60, 130, 30)
  160.         self.button.clicked.connect(self.button_clicked)
  161.  
  162.         self.label_1_1 = QLabel(self)
  163.         self.label_1_1.setGeometry(290, 50, 700, 50)
  164.         self.label_1_1.setFont(QFont("等线", 14))  # 设置字体和字号
  165.         self.label_1_1.setVisible(False)
  166.  
  167.         self.input_text = QLineEdit(self)  # 创建一个输入框
  168.         self.input_text.setGeometry(155, 125, 130, 30)
  169.         self.input_text.setVisible(False)
  170.         self.input_text.setValidator(QIntValidator())
  171.  
  172.         self.label_info = QLabel("清洗指定列", self)  # 创建一个标签
  173.         self.label_info.setFont(QFont('等线', 11))
  174.         self.label_info.setGeometry(155, 95, 130, 30)  # 设置标签位置和大小
  175.         self.label_info.setVisible(False)  # 初始时隐藏标签
  176.  
  177.         self.label_info_1 = QLabel("根据指定列去重", self)
  178.         self.label_info_1.setFont(QFont('等线', 11))
  179.         self.label_info_1.setGeometry(155, 155, 130, 30)
  180.         self.label_info_1.setVisible(False)
  181.  
  182.         self.input_text_1 = QLineEdit(self)
  183.         self.input_text_1.setGeometry(155, 185, 130, 30)
  184.         self.input_text_1.setVisible(False)
  185.         self.input_text_1.setValidator(QIntValidator())
  186.  
  187.         # 指示灯
  188.         self.red_light = QLabel(self)
  189.         self.red_light.setGeometry(10, 170, 20, 20)
  190.         self.red_light.setStyleSheet("background-color: red")
  191.         self.red_light.setVisible(False)
  192.  
  193.         self.green_light = QLabel(self)
  194.         self.green_light.setGeometry(35, 170, 20, 20)
  195.         self.green_light.setStyleSheet("background-color: green")
  196.         self.green_light.setVisible(False)
  197.  
  198.         self.line_horizontal_1 = SeparatorLine1(self)
  199.         self.line_horizontal_1.setGeometry(150, 225, 10000, 2)
  200.         self.line_horizontal_1.setVisible(False)
  201.  
  202.     def button_clicked(self):
  203.         self.label_1_1.setText('(温馨提示，下方的输入框只能输入数字，以下参数非必须参数，可不填)')
  204.         self.input_text.setVisible(not self.input_text.isVisible())  # 切换输入框的可见性
  205.         self.label_info.setVisible(self.input_text.isVisible())
  206.  
  207.         self.input_text_1.setVisible(not self.input_text_1.isVisible())  # 切换输入框的可见性
  208.         self.label_info_1.setVisible(self.input_text_1.isVisible())
  209.  
  210.         self.label_1_1.setVisible(not self.label_1_1.isVisible())
  211.         self.label_1_1.setVisible(self.label_1_1.isVisible())
  212.  
  213.     def select_file(self):  # 选择文件
  214.         file_dialog = QFileDialog()
  215.         file_path, _ = file_dialog.getOpenFileName(self, "选择文件", "", "All Files (*)")
  216.         if file_path:
  217.             self.file_path = file_path
  218.  
  219.     def save_file(self):  # 保存文件
  220.         file_dialog = QFileDialog()
  221.         file_dialog.setWindowTitle("另存为")  # 修改对话框标题
  222.         file_dialog.setNameFilters(["Text Files (*.txt)", "CSV Files (*.csv)",
  223.                                     "Excel Files (*.xlsx *.xls)", "JSON Files (*.json *.jsonl)"])
  224.         file_dialog.selectNameFilter("Excel Files (*.xlsx")
  225.         if file_dialog.exec():
  226.             self.save_path = file_dialog.selectedFiles()[0]
  227.             if os.path.exists(self.save_path):
  228.                 # noinspection PyUnresolvedReferences
  229.                 result = QMessageBox.warning(self, "警告", "文件已存在，是否覆盖？",
  230.                                              QMessageBox.Yes | QMessageBox.No)
  231.                 # noinspection PyUnresolvedReferences
  232.                 if result == QMessageBox.Yes:
  233.                     bag.Bag.save_excel([], self.save_path)
  234.                 else:
  235.                     self.save_path = ''
  236.             else:
  237.                 bag.Bag.save_excel([], self.save_path)
  238.  
  239.     def run(self):  # 开始清洗
  240.         resp = judge(self.file_path)
  241.         total = len(resp)
  242.  
  243.         def clean_1(ls, col_number, col_name):
  244.             self.red_light.setVisible(True)
  245.             result = []
  246.             for i, info in enumerate(tqdm(ls)):
  247.                 mid = []
  248.                 for value in info[col_number].split('\n'):
  249.                     if re.sub(r'\s', '', value):
  250.                         text = value.lstrip(',.?!;:，。？；：')
  251.                         text1 = text.strip()
  252.                         text2 = emoji.replace_emoji(text1, replace='<emoji>')
  253.                         mid.append(text2)
  254.                     else:
  255.                         pass
  256.                 info[col_number] = '\n'.join(mid)
  257.                 result.append(info)
  258.  
  259.                 # 更新进度条的值
  260.                 progress = int((i + 1) / total * 100)
  261.                 self.progress_bar.setValue(progress)
  262.                 QApplication.processEvents()  # 刷新界面
  263.  
  264.             sign = []
  265.             new_result = [item for item in result if item[col_name] not in sign and not sign.append(item[col_name])]
  266.  
  267.             self.red_light.setVisible(False)
  268.             self.green_light.setVisible(True)
  269.  
  270.             if bool(self.save_path):
  271.                 bag.Bag.save_excel(new_result, self.save_path)
  272.             else:
  273.                 self.save_file()
  274.                 bag.Bag.save_excel(new_result, self.save_path)
  275.             time.sleep(1)
  276.             self.green_light.setVisible(False)
  277.  
  278.         def clean_2(ls, col_number):
  279.             self.red_light.setVisible(True)
  280.             result = []
  281.             for i, info in enumerate(tqdm(ls)):
  282.                 mid = []
  283.                 for value in info[col_number].split('\n'):
  284.                     if re.sub(r'\s', '', value):
  285.                         text = value.lstrip(',.?!;:，。？；：')
  286.                         text1 = text.strip()
  287.                         text2 = emoji.replace_emoji(text1, replace='<emoji>')
  288.                         mid.append(text2)
  289.                     else:
  290.                         pass
  291.                 info[col_number] = '\n'.join(mid)
  292.                 result.append(info)
  293.  
  294.                 progress = int((i + 1) / total * 100)
  295.                 self.progress_bar.setValue(progress)
  296.                 QApplication.processEvents()  # 刷新界面
  297.  
  298.             self.red_light.setVisible(False)
  299.             self.green_light.setVisible(True)
  300.  
  301.             if bool(self.save_path):
  302.                 bag.Bag.save_excel(result, self.save_path)
  303.             else:
  304.                 self.save_file()
  305.                 bag.Bag.save_excel(result, self.save_path)
  306.             time.sleep(1)
  307.             self.green_light.setVisible(False)
  308.  
  309.         def clean_3(ls, col_name):
  310.             self.red_light.setVisible(True)
  311.             result = []
  312.             for i, info in enumerate(tqdm(ls)):
  313.                 mid1 = []
  314.                 for info1 in info:
  315.                     mid = []
  316.                     for value in info1.split('\n'):
  317.                         if re.sub(r'\s', '', value):
  318.                             text = value.lstrip(',.?!;:，。？；：')
  319.                             text1 = text.strip()
  320.                             text2 = emoji.replace_emoji(text1, replace='<emoji>')
  321.                             mid.append(text2)
  322.                         else:
  323.                             pass
  324.                     mid1.append('\n'.join(mid))
  325.                 result.append(mid1)
  326.  
  327.                 progress = int((i + 1) / total * 100)
  328.                 self.progress_bar.setValue(progress)
  329.                 QApplication.processEvents()  # 刷新界面
  330.  
  331.             sign = []
  332.             new_result = [item for item in result if item[col_name] not in sign and not sign.append(item[col_name])]
  333.  
  334.             self.red_light.setVisible(False)
  335.             self.green_light.setVisible(True)
  336.  
  337.             if bool(self.save_path):
  338.                 bag.Bag.save_excel(new_result, self.save_path)
  339.             else:
  340.                 self.save_file()
  341.                 bag.Bag.save_excel(new_result, self.save_path)
  342.             time.sleep(1)
  343.             self.green_light.setVisible(False)
  344.  
  345.         def clean_4(ls):
  346.             self.red_light.setVisible(True)
  347.             result = []
  348.             for i, info in enumerate(tqdm(ls)):
  349.                 mid1 = []
  350.                 for info1 in info:
  351.                     mid = []
  352.                     for value in info1.split('\n'):
  353.                         if re.sub(r'\s', '', value):
  354.                             text = value.lstrip(',.?!;:，。？；：')
  355.                             text1 = text.strip()
  356.                             text2 = emoji.replace_emoji(text1, replace='<emoji>')
  357.                             mid.append(text2)
  358.                         else:
  359.                             pass
  360.                     mid1.append('\n'.join(mid))
  361.                 result.append(mid1)
  362.  
  363.                 progress = int((i + 1) / total * 100)
  364.                 self.progress_bar.setValue(progress)
  365.                 QApplication.processEvents()  # 刷新界面
  366.  
  367.             self.red_light.setVisible(False)
  368.             self.green_light.setVisible(True)
  369.  
  370.             if bool(self.save_path):
  371.                 bag.Bag.save_excel(result, self.save_path)
  372.             else:
  373.                 self.save_file()
  374.                 bag.Bag.save_excel(result, self.save_path)
  375.  
  376.             time.sleep(1)
  377.             self.green_light.setVisible(False)
  378.  
  379.         additional_options = self.input_text.text()  # 获取输入框的文本内容
  380.         additional_options_1 = self.input_text_1.text()
  381.         col_num = additional_options
  382.         tag_name = additional_options_1
  383.         """判断是否夹带清洗附加条件"""
  384.         target = bool(col_num)
  385.         target_1 = bool(tag_name)
  386.  
  387.         # 进度条
  388.         self.progress_bar.setVisible(True)
  389.         self.line_horizontal_1.setVisible(True)
  390.  
  391.         # 处理异常
  392.         try:
  393.             if target and target_1:  # 清洗指定列以及根据某某标签去重
  394.                 clean_1(resp, int(col_num)-1, int(tag_name)-1)
  395.             elif target and not target_1:   # 清洗子指定列，不去重
  396.                 clean_2(resp, int(col_num)-1)
  397.             elif not target and target_1:    # 清洗全文再根据某某列去重
  398.                 clean_3(resp, int(tag_name)-1)
  399.             else:    # 清洗全文，不去重
  400.                 clean_4(resp)
  401.             QMessageBox.information(self, "完成", "数据清洗完成")
  402.         except Exception as e:
  403.             error_message = str(e)
  404.             QMessageBox.critical(self, "错误", error_message)
  405.  
  406.  
  407. # 压缩、解压
  408. class CompressionDecompression(Layout):
  409.     def __init__(self):
  410.         super().__init__()
  411.         self.layout = QVBoxLayout()
  412.  
  413.         self.file_path = None
  414.  
  415.         self.button_compress = QPushButton("压缩文件", self)
  416.         self.button_compress.setFont(QFont('等线', 11))
  417.         self.button_compress.setGeometry(10, 60, 130, 30)
  418.         self.button_compress.clicked.connect(self.on_button_clicked)
  419.  
  420.         self.button_extract = QPushButton("解压文件", self)
  421.         self.button_extract.setFont(QFont('等线', 11))
  422.         self.button_extract.setGeometry(10, 95, 130, 30)
  423.         self.button_extract.clicked.connect(self.on_button_clicked1)
  424.  
  425.     def on_button_clicked(self):
  426.         selected_file = bool(self.file_path)
  427.         if selected_file:
  428.             extract_path = QFileDialog.getExistingDirectory(self, "另存为")
  429.             if bool(extract_path):
  430.                 unzip_file(selected_file, extract_path)
  431.                 QMessageBox.information(self, 'success', '解压成功！')
  432.             else:
  433.                 QMessageBox.critical(self, 'error', '解压失败')
  434.         else:
  435.             self.select_file()
  436.             extract_path = QFileDialog.getExistingDirectory(self, "另存为")
  437.             if bool(extract_path):
  438.                 unzip_file(self.file_path, extract_path)
  439.                 QMessageBox.information(self, 'success', '解压成功！')
  440.             else:
  441.                 QMessageBox.critical(self, 'error', '解压失败')
  442.  
  443.     def on_button_clicked1(self):
  444.         selected_file = bool(self.file_path)
  445.         if selected_file:
  446.             extract_path = QFileDialog.getExistingDirectory(window, "选择文件夹", options=QFileDialog.ShowDirsOnly)
  447.             if bool(extract_path):
  448.                 self.compress_to_zip(selected_file, extract_path)
  449.                 QMessageBox.information(self, 'success', '压缩成功！')
  450.             else:
  451.                 QMessageBox.critical(self, 'error', '压缩失败')
  452.         else:
  453.             self.select_folder()
  454.             extract_path = QFileDialog.getExistingDirectory(window, "选择文件夹", options=QFileDialog.ShowDirsOnly)
  455.             if bool(extract_path):
  456.                 self.compress_to_zip(self.file_path, extract_path)
  457.                 QMessageBox.critical(self, 'success', '压缩成功！')
  458.             else:
  459.                 QMessageBox.critical(self, 'error', '压缩失败')
  460.  
  461.     def select_file(self):  # 选择文件
  462.         file_dialog = QFileDialog()
  463.         file_path, _ = file_dialog.getOpenFileName(self, "选择文件", "", "All Files (*)")
  464.         if file_path:
  465.             self.file_path = file_path
  466.  
  467.     def select_folder(self):
  468.         file_path, _ = QFileDialog.getExistingDirectory(window, "选择文件夹", options=QFileDialog.ShowDirsOnly)
  469.         if file_path:
  470.             self.file_path = file_path
  471.  
  472.     def compress_to_zip(self, file_path, zip_path):
  473.         with zipfile.ZipFile(zip_path, 'w') as zipf:
  474.             zipf.write(file_path, arcname='compressed_file.txt')
  475.  
  476.  
  477. # 合并表格
  478. # noinspection PyMethodMayBeStatic
  479. class SelectDirectory(Layout):
  480.     def __init__(self):
  481.         super().__init__()
  482.         self.layout = QVBoxLayout()
  483.         self.button_extract = QPushButton("选择合并文件路径", self)
  484.         self.button_extract.setFont(QFont('等线', 11))
  485.         self.button_extract.setGeometry(10, 60, 130, 30)
  486.         self.button_extract.clicked.connect(self.choose_folder)
  487.  
  488.         self.progress_bar = QProgressBar(self)
  489.         self.progress_bar.setGeometry(155, 100, 668, 28)
  490.         self.progress_bar.setVisible(False)
  491.  
  492.         self.red_light = QLabel(self)
  493.         self.red_light.setGeometry(10, 100, 20, 20)
  494.         self.red_light.setStyleSheet("background-color: red")
  495.         self.red_light.setVisible(False)
  496.  
  497.         self.green_light = QLabel(self)
  498.         self.green_light.setGeometry(35, 100, 20, 20)
  499.         self.green_light.setStyleSheet("background-color: green")
  500.         self.green_light.setVisible(False)
  501.  
  502.     def choose_folder(self):
  503.         # noinspection PyUnresolvedReferences
  504.         self.red_light.setVisible(True)
  505.         self.progress_bar.setVisible(True)
  506.         folder = QFileDialog.getExistingDirectory(window, "选择文件夹", options=QFileDialog.ShowDirsOnly)
  507.         save_path = folder+'\\'+'合并结果.xlsx'
  508.         # 清空前一次合并结果
  509.         if os.path.isfile(save_path):
  510.             os.remove(save_path)
  511.         else:
  512.             pass
  513.         file_name = os.listdir(folder)
  514.         consolidated_number = file_name  # 合并索引,后期需要可优化
  515.         total = len(consolidated_number)
  516.         workbook = xlsxwriter.Workbook(save_path, options={'strings_to_urls': False})
  517.         worksheet = workbook.add_worksheet('Sheet1')
  518.         count_1 = 0
  519.         n = 0
  520.         for i, _ in enumerate(tqdm(consolidated_number)):
  521.             path = folder + '\\' + _.replace('\n', '')
  522.             book = openpyxl.load_workbook(path)
  523.             sheet = book['Sheet1']
  524.             rows = sheet.max_row
  525.             columns = sheet.max_column
  526.             a = 1
  527.             if n == 0:
  528.                 a = 0
  529.             for k in range(a, rows):
  530.                 for j in range(columns):
  531.                     worksheet.write(n, j, str(sheet.cell(k + 1, j + 1).value))
  532.                 n = n + 1
  533.             count_1 += 1
  534.             book.close()
  535.             # 更新进度条的值
  536.             progress = int((i + 1) / total * 100)
  537.             self.progress_bar.setValue(progress)
  538.             QApplication.processEvents()  # 刷新界面
  539.         workbook.close()
  540.         self.red_light.setVisible(False)
  541.         self.green_light.setVisible(True)
  542.         QMessageBox.information(self, "success", f'合并完成，合并文件路径：{folder}/合并文件.xlsx')
  543.         time.sleep(3)
  544.         self.green_light.setVisible(False)
  545.  
  546.     @staticmethod
  547.     def save_excel(_ls, path, _sheet_name='Sheet1', batch_size=10000):
  548.         _book = xlsxwriter.Workbook(path, options={'strings_to_urls': False})
  549.         _sheet = _book.add_worksheet(_sheet_name)
  550.         batch_size = batch_size
  551.         for i in range(0, len(_ls), batch_size):
  552.             batch_data = _ls[i:i + batch_size]
  553.             for _i in range(len(batch_data)):
  554.                 for __i in range(len(batch_data[_i])):
  555.                     _sheet.write(_i + i, __i, json.dumps(batch_data[_i][__i], ensure_ascii=False, indent=2))
  556.         _book.close()
  557.  
  558.  
  559. if __name__ == "__main__":
  560.     app = QApplication(sys.argv)
  561.     window = Layout()
  562.     window.show()
  563.     sys.exit(app.exec())
  564.

最后，如果你觉得本教程对你有所帮助，不妨点赞并关注我的CSDN账号。我会持续为大家带来更多有趣且实用的教程和资源。谢谢大家的支持！

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Li_阴宅/article/detail/872101
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号