一、引言
因办公要求,经常需要统计“底层人员”上交的各种文件,人数少还好说,人多就是一个稍微复杂的问题了。当然这个问题也可以通过“暴 力”的方式解决,但是工作效率会大大折扣。所以,为极大提高办公效率,就谋生了这个想法。
二、gui界面设计
使用pyqt5进行界面的搭建,最终界面如下:
1.第一步:确定被读取文件所在的文件夹。
2.第二步:确定最终读取结果是否需要保留其文件类型(即后缀)。可根据个人需求而定,以我的工作经验来说,第二种“不保留”是最常见的,即只获取文件名称。
3.第三步:选择最终读取结果存放的文件类型,下拉列表中包含了最常用的五种文件类型:txt文本文件、.doc文档、.docx文档、.xls工作表和.xlsx工作表(如下图所示)。若跳过此步骤,默认保存文件类型为txt文本文件。
4.最后单击“开始读取”按钮,即可成功获取当前目录下所有文件的名称并存储在步骤三所选的文件类型中。若还想继续读取其他文件名称,从步骤一开始重复即可;否则,单击“退出系统”即可退出程序即可。
最后附上通过pyuic5产生的gui界面代码jiemian.py:
# -*- coding: utf-8 -*- # form implementation generated from reading ui file 'jiemian.ui' # # created by: pyqt5 ui code generator 5.15.11 # # 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.setenabled(true) form.resize(460, 500) form.setminimumsize(qtcore.qsize(460, 500)) form.setmaximumsize(qtcore.qsize(460, 500)) icon = qtgui.qicon() icon.addpixmap(qtgui.qpixmap(":/image1.png"), qtgui.qicon.normal, qtgui.qicon.off) form.setwindowicon(icon) self.groupbox = qtwidgets.qgroupbox(form) self.groupbox.setgeometry(qtcore.qrect(40, 180, 381, 61)) self.groupbox.setautofillbackground(false) self.groupbox.settitle("") self.groupbox.setflat(false) self.groupbox.setobjectname("groupbox") self.radiobutton = qtwidgets.qradiobutton(self.groupbox) self.radiobutton.setgeometry(qtcore.qrect(90, 40, 81, 16)) self.radiobutton.setcursor(qtgui.qcursor(qtcore.qt.arrowcursor)) self.radiobutton.setobjectname("radiobutton") self.label_2 = qtwidgets.qlabel(self.groupbox) self.label_2.setgeometry(qtcore.qrect(20, 10, 281, 21)) font = qtgui.qfont() font.setfamily("adobe arabic") font.setpointsize(12) font.setbold(false) font.setweight(50) self.label_2.setfont(font) self.label_2.setobjectname("label_2") self.radiobutton_2 = qtwidgets.qradiobutton(self.groupbox) self.radiobutton_2.setgeometry(qtcore.qrect(200, 40, 81, 16)) self.radiobutton_2.setcursor(qtgui.qcursor(qtcore.qt.arrowcursor)) self.radiobutton_2.setobjectname("radiobutton_2") self.label = qtwidgets.qlabel(self.groupbox) self.label.setgeometry(qtcore.qrect(290, 0, 201, 41)) font = qtgui.qfont() font.setfamily("adobe arabic") font.setpointsize(20) font.setbold(false) font.setweight(50) self.label.setfont(font) self.label.setobjectname("label") self.groupbox_2 = qtwidgets.qgroupbox(form) self.groupbox_2.setgeometry(qtcore.qrect(40, 270, 381, 71)) self.groupbox_2.setcursor(qtgui.qcursor(qtcore.qt.arrowcursor)) self.groupbox_2.settitle("") self.groupbox_2.setobjectname("groupbox_2") self.label_4 = qtwidgets.qlabel(self.groupbox_2) self.label_4.setgeometry(qtcore.qrect(20, 10, 311, 21)) font = qtgui.qfont() font.setfamily("adobe arabic") font.setpointsize(12) font.setbold(false) font.setweight(50) self.label_4.setfont(font) self.label_4.setobjectname("label_4") self.combobox = qtwidgets.qcombobox(self.groupbox_2) self.combobox.setgeometry(qtcore.qrect(60, 40, 261, 22)) self.combobox.setobjectname("combobox") self.combobox.additem("") self.combobox.additem("") self.combobox.additem("") self.combobox.additem("") self.combobox.additem("") self.label_5 = qtwidgets.qlabel(form) self.label_5.setgeometry(qtcore.qrect(270, 20, 141, 31)) font = qtgui.qfont() font.setfamily("adobe arabic") font.setpointsize(16) self.label_5.setfont(font) self.label_5.setobjectname("label_5") self.groupbox_5 = qtwidgets.qgroupbox(form) self.groupbox_5.setgeometry(qtcore.qrect(40, 370, 381, 71)) self.groupbox_5.settitle("") self.groupbox_5.setobjectname("groupbox_5") self.label_9 = qtwidgets.qlabel(self.groupbox_5) self.label_9.setgeometry(qtcore.qrect(20, 10, 231, 21)) font = qtgui.qfont() font.setfamily("adobe arabic") font.setpointsize(12) font.setbold(false) font.setweight(50) self.label_9.setfont(font) self.label_9.setobjectname("label_9") self.pushbutton_2 = qtwidgets.qpushbutton(self.groupbox_5) self.pushbutton_2.setgeometry(qtcore.qrect(200, 40, 121, 23)) self.pushbutton_2.setobjectname("pushbutton_2") self.pushbutton = qtwidgets.qpushbutton(self.groupbox_5) self.pushbutton.setgeometry(qtcore.qrect(60, 40, 121, 23)) self.pushbutton.setobjectname("pushbutton") self.label_8 = qtwidgets.qlabel(form) self.label_8.setgeometry(qtcore.qrect(50, 20, 251, 31)) font = qtgui.qfont() font.setfamily("adobe arabic") font.setpointsize(18) font.setbold(false) font.setweight(50) self.label_8.setfont(font) self.label_8.setobjectname("label_8") self.label_10 = qtwidgets.qlabel(form) self.label_10.setgeometry(qtcore.qrect(350, 10, 71, 51)) self.label_10.settext("") self.label_10.setpixmap(qtgui.qpixmap(":/image1.png")) self.label_10.setobjectname("label_10") self.label_6 = qtwidgets.qlabel(form) self.label_6.setgeometry(qtcore.qrect(60, 90, 311, 21)) font = qtgui.qfont() font.setfamily("adobe arabic") font.setpointsize(12) font.setbold(false) font.setweight(50) self.label_6.setfont(font) self.label_6.setobjectname("label_6") self.pushbutton_3 = qtwidgets.qpushbutton(form) self.pushbutton_3.setgeometry(qtcore.qrect(100, 120, 261, 23)) self.pushbutton_3.setobjectname("pushbutton_3") self.groupbox_3 = qtwidgets.qgroupbox(form) self.groupbox_3.setgeometry(qtcore.qrect(40, 80, 381, 80)) self.groupbox_3.settitle("") self.groupbox_3.setobjectname("groupbox_3") self.groupbox_3.raise_() self.groupbox_5.raise_() self.groupbox_2.raise_() self.groupbox.raise_() self.label_5.raise_() self.label_8.raise_() self.label_10.raise_() self.label_6.raise_() self.pushbutton_3.raise_() self.retranslateui(form) self.pushbutton_2.clicked.connect(form.close) # type: ignore qtcore.qmetaobject.connectslotsbyname(form) def retranslateui(self, form): _translate = qtcore.qcoreapplication.translate form.setwindowtitle(_translate("form", "read_file")) self.radiobutton.settext(_translate("form", "保留")) self.label_2.settext(_translate("form", "二、文件名称是否需要保留其类型后缀")) self.radiobutton_2.settext(_translate("form", "不保留")) self.label.settext(_translate("form", "(.xxx):")) self.label_4.settext(_translate("form", "三、请选择获取结果最终存放的文件类型:")) self.combobox.setitemtext(0, _translate("form", "文本文档.txt")) self.combobox.setitemtext(1, _translate("form", "doc文档.doc")) self.combobox.setitemtext(2, _translate("form", "dcox文档.docx")) self.combobox.setitemtext(3, _translate("form", "xls工作表.xls")) self.combobox.setitemtext(4, _translate("form", "xlsx工作表.xlsx")) self.label_5.settext(_translate("form", "designed by")) self.label_9.settext(_translate("form", "四、请选择以下操作命令:")) self.pushbutton_2.settext(_translate("form", "退出系统")) self.pushbutton.settext(_translate("form", "开始读取")) self.label_8.settext(_translate("form", "文件名称获取系统")) self.label_6.settext(_translate("form", "一、请选择待获取文件所在的文件夹:")) self.pushbutton_3.settext(_translate("form", "点击选择待读取文件所在的文件夹")) import ziyuan_rc //用于个人logo或图标显示,可根据个人需求设置,也可注掉
三、程序详解
1.导入所需模块
import sys,os from jiemian import * from pyqt5.qtwidgets import qapplication, qwidget from docx import document from openpyxl import workbook
2.调整窗口大小
# 保持窗口大小和qtdesigner中的一致 from pyqt5 import qtcore qtcore.qcoreapplication.setattribute(qtcore.qt.aa_enablehighdpiscaling)
这一步要额外注意:当在pyqt5中的设计界面与使用pyuic生成的界面大小不一致时,需要导入qtcore模块实现自适应缩放。
设计界面
生成界面
加上上述代码后,两者才会变得一致。
3.弹出选择文件路径对话框
def lujing(self): filepath = qtwidgets.qfiledialog.getexistingdirectory(self, "选取存放待读取文件的文件夹") # 获取文件夹的路径 if filepath: self.path = filepath self.lujing_flag = true
此def对应着步骤一。最后设立一个标志位lujing_flag,以此来判断操作者是否完成了步骤一(后续会用到)。
对话框效果如下:
4.对后缀的处理
def xuanze(self): filelist = os.listdir(self.path) if self.radiobutton.ischecked(): # 保留后缀 self.result_list = filelist else: if self.radiobutton_2.ischecked(): # 去掉待命名文件的格式后缀 baoliu_list = [] # 存放最终读取结果 for filename in filelist: for zifu in filename: if zifu == ".": dian_suoyin = filename.index(zifu) baoliu_list.append(filename[:dian_suoyin]) break self.result_list = baoliu_list
如果用户选择的是保留后缀,则将filelist的内容赋给result_list;否则,通过循环定位后缀标识符“.”在对应文件名中的索引,利用此索引对此文件名依次切片,最终获得纯文件名(不保留后缀)。
5.写入并生成存储文件
def shengcheng(self): if self.lujing_flag == true: if (self.radiobutton.ischecked()==false) and (self.radiobutton_2.ischecked()==false): qtwidgets.qmessagebox.critical(self, '提示', '请完成步骤二!') else: selected_index = self.combobox.currentindex() wenjian_shengcheng(selected_index, self.result_list) qtwidgets.qmessagebox.information(self, '成功', '文件名称读取结果保存在当前目录下,请查看!') else: qtwidgets.qmessagebox.critical(self, '提示', '请完成步骤一!')
依次对步骤完成情况进行判断,并通过自定义函数wenjian_shengcheng写入并生成文件。
自定义函数wenjian_shengcheng如下:
def wenjian_shengcheng(suoyin, content): name = "read_result" # 产生不同种类的文件 match suoyin: case 0: # 生成文本文档txt with open(name+'.txt','w') as f: for item in content: f.write(f"{item}\n") case 1: # 生成doc文档 doc = document() for item in content: paragraph = doc.add_paragraph(item) doc.save(name+'.doc') case 2: # 生成docx文档 doc = document() for item in content: paragraph = doc.add_paragraph(item) doc.save(name+'.docx') case 3: # 生成xls工作表 wb = workbook() ws = wb.active for row in range(1, len(content) + 1): ws.cell(row=row, column=1, value=content[row - 1]) wb.save(name+'.xls') case 4: # 生成xlsx工作表 wb = workbook() ws = wb.active for row in range(1, len(content) + 1): ws.cell(row=row, column=1, value=content[row - 1]) wb.save(name+'.xlsx')
四、总程序代码read_file.py
import sys,os from jiemian import * from pyqt5.qtwidgets import qapplication, qwidget from docx import document from openpyxl import workbook # 保持窗口大小和qtdesigner中的一致 from pyqt5 import qtcore qtcore.qcoreapplication.setattribute(qtcore.qt.aa_enablehighdpiscaling) class login_interface(qwidget, ui_form): def __init__(self): super(qwidget, self).__init__() self.setupui(self) # 绑定信号 self.radiobutton.clicked.connect(self.xuanze) self.radiobutton_2.clicked.connect(self.xuanze) self.pushbutton.clicked.connect(self.shengcheng) self.pushbutton_3.clicked.connect(self.lujing) self.result_list = [] # 在__init__构造函数中定义,通过self关键字访问,每个实例拥有独立副本 self.path = "" self.lujing_flag = false def lujing(self): filepath = qtwidgets.qfiledialog.getexistingdirectory(self, "选取存放待读取文件的文件夹") # 获取文件夹的路径 if filepath: self.path = filepath self.lujing_flag = true def xuanze(self): filelist = os.listdir(self.path) if self.radiobutton.ischecked(): # 保留后缀 self.result_list = filelist else: if self.radiobutton_2.ischecked(): # 去掉待命名文件的格式后缀 baoliu_list = [] # 存放最终读取结果 for filename in filelist: for zifu in filename: if zifu == ".": dian_suoyin = filename.index(zifu) baoliu_list.append(filename[:dian_suoyin]) break self.result_list = baoliu_list def shengcheng(self): if self.lujing_flag == true: if (self.radiobutton.ischecked()==false) and (self.radiobutton_2.ischecked()==false): qtwidgets.qmessagebox.critical(self, '提示', '请完成步骤二!') else: selected_index = self.combobox.currentindex() wenjian_shengcheng(selected_index, self.result_list) qtwidgets.qmessagebox.information(self, '成功', '文件名称读取结果保存在当前目录下,请查看!') else: qtwidgets.qmessagebox.critical(self, '提示', '请完成步骤一!') def wenjian_shengcheng(suoyin, content): name = "read_result" # 产生不同种类的文件 match suoyin: case 0: # 生成文本文档txt with open(name+'.txt','w') as f: for item in content: f.write(f"{item}\n") case 1: # 生成doc文档 doc = document() for item in content: paragraph = doc.add_paragraph(item) doc.save(name+'.doc') case 2: # 生成docx文档 doc = document() for item in content: paragraph = doc.add_paragraph(item) doc.save(name+'.docx') case 3: # 生成xls工作表 wb = workbook() ws = wb.active for row in range(1, len(content) + 1): ws.cell(row=row, column=1, value=content[row - 1]) wb.save(name+'.xls') case 4: # 生成xlsx工作表 wb = workbook() ws = wb.active for row in range(1, len(content) + 1): ws.cell(row=row, column=1, value=content[row - 1]) wb.save(name+'.xlsx') if __name__ == '__main__': app = qapplication(sys.argv) w = login_interface() w.show() sys.exit(app.exec_())
到此这篇关于python+pyqt实现一键生成文件目录的文章就介绍到这了,更多相关python生成文件目录内容请搜索代码网以前的文章或继续浏览下面的相关文章希望大家以后多多支持代码网!
发表评论