当前位置：网站首页>Combine pyqt5 to develop one click conversion software for office documents, and there is no need to open members to transfer files in the future

Combine pyqt5 to develop one click conversion software for office documents, and there is no need to open members to transfer files in the future

2022-07-21 12:06:00 【InfoQ】

Preface

Office automation can greatly improve our work efficiency , And the use of automated office can effectively avoid boring mechanical operations , Free your hands to do other more meaningful things . Now add Python It can provide a large number of open source automated office libraries , Can quickly achieve many needs to open vip Functions that can be used . For example, the format conversion between documents . such as , I want to make an invitation . If office It's hard to master . Making one by one is also a very painful thing , utilize Python You can generate invitations in batch . In addition to automated office ,python It can also realize many interesting functions , You can learn more about what you are interested in , Next, this article takes you hand-in-hand to realize the document conversion function and encapsulate it into pyqt5, And pack it into exe Executable file

Get ready

Because I want to encapsulate the daily operation . Than word Document transfer PDF/PDF turn word The following libraries need to be installed for document and text processing
pip install pdf2docx
pip install docx2pdf #word turn pdf
pyqt5 Children's shoes that you don't know can refer to this article :《
It's worth learning  Python GUI  library  - pyQt5  Quick start and beautiful interface design experience
》
operating system ：windows 64 position
Next, let's go into practice .

Practice

The first is to import the relevant library
import sys
import os
from docx2pdf import convert
from pdf2docx import Converter
from PyQt5.QtWidgets import *
It involves reading and writing files, so , So you need to import os Libraries and sys library .

Use qt5 Design GUI
class MainForm(QWidget):
 def __init__(self, name = 'MainForm'):
 super(MainForm,self).__init__()
 self.setWindowTitle(name)
 self.cwd = os.getcwd() #  Get the current program file location
 self.resize(600,400) #  Set the window size

 #  Select the file to be transferred
 self.btn_chooseFile = QPushButton(self)
 self.btn_chooseFile.setObjectName("btn_chooseFile")
 self.btn_chooseFile.setText(" Select the file to be converted ")

 #  Save directory selection
 self.btn_chooseDir = QPushButton(self)
 self.btn_chooseDir.setObjectName("btn_chooseDir")
 self.btn_chooseDir.setText(" Save to file ")

 # Source
 self.textEdit = QTextEdit(self)
 self.textEdit.setEnabled(True)
 self.textEdit.setAccessibleName("")
 self.textEdit.setPlaceholderText(' Please select a file ')
 self.textEdit.setFixedSize(580,30)
 self.textEdit.setObjectName("textEdit")
 #  preservation
 self.textEdit2 = QTextEdit(self)
 self.textEdit2.setEnabled(True)
 self.textEdit2.setAccessibleName("")
 self.textEdit2.setPlaceholderText(' Please select the save Directory ')
 self.textEdit2.setFixedSize(580, 30)
 self.textEdit2.setObjectName("textEdit2")

 # TXT Generate SQL
 self.btn_saveFile = QPushButton(self)
 self.btn_saveFile.setObjectName("btn_saveFiletxt2sql")
 self.btn_saveFile.setText("TXT Generate SQL")

 # Word turn PDF
 self.btn_saveFile2 = QPushButton(self)
 self.btn_saveFile2.setObjectName("btn_saveFilew2pdf")
 self.btn_saveFile2.setText("Word turn PDF")

 # PDF turn Word
 self.btn_saveFile3 = QPushButton(self)
 self.btn_saveFile3.setObjectName("btn_saveFilepdf2w")
 self.btn_saveFile3.setText("PDF turn Word")

 self.eittxt = QLabel(self)
 self.eittxt.setText(" explain : Please select the corresponding button conversion according to the file type ")
 self.eittxt.setObjectName("eittxt")
 self.eittxt.setFixedSize(580, 30)

 #  Setting up layout
 layout = QVBoxLayout()
 layout.addWidget(self.btn_chooseFile)
 layout.addWidget(self.textEdit)
 layout.addWidget(self.btn_chooseDir)
 layout.addWidget(self.textEdit2)
 layout.addWidget(self.eittxt)
 layout.addWidget(self.btn_saveFile)
 layout.addWidget(self.btn_saveFile2)
 layout.addWidget(self.btn_saveFile3)
 self.setLayout(layout)

 #  Bind click event to button
 self.btn_chooseDir.clicked.connect(self.slot_btn_chooseDir)
 self.btn_chooseFile.clicked.connect(self.slot_btn_chooseFile)
 self.btn_saveFile.clicked.connect(self.slot_btn_saveFile)
 self.btn_saveFile2.clicked.connect(self.slot_wtopdfbtn_saveFile)
 self.btn_saveFile3.clicked.connect(self.slot_pdftowbtn_saveFile)
Then give the function that implements the button click event in the class
 def slot_btn_chooseDir(self):
 fileName_choose, filetype = QFileDialog.getSaveFileName(self,
 " Save the file ",
 self.cwd, #  Starting path
 "All Files (*);;Text Files (*.txt)")

 if fileName_choose == "":
 print("\n deselect ")
 return

 print("\n You choose the file you want to save as :")
 print(fileName_choose)
 print(" File filter type : ", filetype)
 self.textEdit2.setText(fileName_choose)

 def slot_btn_chooseFile(self):
 fileName_choose, filetype = QFileDialog.getOpenFileName(self,
 " Select file ",
 self.cwd, #  Starting path
 "All Files (*);;Text Files (*.txt)") #  Set file extension filtering , Use double semicolon intervals

 if fileName_choose == "":
 print("\n deselect ")
 return

 print("\n The document you selected is :")
 print(fileName_choose)
 self.textEdit.setText(fileName_choose)
 print(" File filter type : ",filetype)


 #txt turn sql
 def slot_btn_saveFile(self):
 with open(self.textEdit.toPlainText(), 'r',encoding="utf-8") as file:
 while True:
 # readline() Default newline
 txt = file.readline()
 if txt:
 print(txt, end='')
 with open(self.textEdit2.toPlainText(), 'a+', encoding='utf-8') as wf:
 text = 'insert into table (code) value ("' + txt + '"); \n'
 wf.write(text)
 else:
 break

 #word turn pdf
 def slot_wtopdfbtn_saveFile(self):
 convert(self.textEdit.toPlainText(), self.textEdit2.toPlainText())

 #pdf turn word
 def slot_pdftowbtn_saveFile(self):
 # pdf File name
 pdf_name = self.textEdit.toPlainText()
 #  To convert docx File name
 docx_name = self.textEdit2.toPlainText()
 #  load pdf file
 cv = Converter(pdf_name)
 cv.convert(docx_name)
 cv.close()
Then there is the call window
if __name__=="__main__":
 app = QApplication(sys.argv)
 mainForm = MainForm(" File conversion ")
 mainForm.show()
 sys.exit(app.exec_())
This simply realizes the format conversion between various document files , Article txt turn sql Statement sql I have written it in the code , You can also add an input box to the page to input by yourself , And for convenience , You can also use pyinstaller Pack it up exe Executable file
pyinstaller
Installation command for ：
pip install pyinstaller
If the above command cannot be installed, you can use the image installation of Tsinghua or Douban
pip install -i https://pypi.douban.com/simple/ pyinstaller # Douban source
pip install -i https://pypi.tuna.tsinghua.edu.cn/simple pyinstaller # Tsinghua source
The packaging process may be long ; Wait slowly . notice succesfully It indicates that the packaging is successful .
null
null
It can be seen from the above figure that the file is very large , And it opens slowly , You can think about how to package files smaller , Faster startup ？ The next exam ~ ha-ha
原网站

版权声明
本文为[InfoQ]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/202/202207201654472300.html

边栏推荐

猜你喜欢

随机推荐