Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

wangy8961/python3-pyqt5-process-csv-data

Open more actions menu

Repository files navigation

Python PyQt5 PyInstaller

1. 搭建环境

打开cmd命令行,切换到 D:\python-code\python3-pyqt5-process-csv-data 目录下

D:\python-code\python3-pyqt5-process-csv-data> python -m venv venv3

2. 激活

D:\python-code\python3-pyqt5-process-csv-data> venv3\Scripts\activate
(venv3) D:\python-code\python3-pyqt5-process-csv-data>

3. 安装包

(venv3) D:\python-code\python3-pyqt5-process-csv-data> pip install pyqt5
(venv3) D:\python-code\python3-pyqt5-process-csv-data> pip install pyinstaller

4. 图标

创建images.qrc,注意ico图标放在当前目录下的子目录img中:

<RCC>
  <qresource prefix="/" >
    <file>img/logo.ico</file>
  </qresource>
</RCC>

生成images_pyqt.py,去文件目录下执行:

(venv3) D:\python-code\python3-pyqt5-process-csv-data> pyrcc5 -o images_pyqt.py images.qrc

最后在代码中import images_pyqt,并且修改下图片路径,一定要在路径前面加上冒号:

import images_pyqt

def init_ui(self):
    self.setWindowIcon(QIcon(':/img/logo.ico'))  # 图标

5. 打包成exe

(venv3) D:\python-code\python3-pyqt5-process-csv-data> pyinstaller --name Madman --onefile --windowed --icon=D:\python-code\python3-pyqt5-process-csv-data\logo.ico -w --paths=D:\python-code\python3-pyqt5-process-csv-data\venv3\Lib\site-packages --paths=D:\python-code\python3-pyqt5-process-csv-data pyqt5_process_csv_data.py

About

使用Python3 csv模块处理快收后台导出的商场优惠活动交易数据,统计各类优惠券的核销数量,以及实收款等汇总数据。测试数据 "1. 财务明细数据.csv" 已经删除了敏感信息,由于客户不想使用脚本,所以使用 PyQt5 编写了图形界面,再使用 pyinstaller 打包为可执行程序

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages

Morty Proxy This is a proxified and sanitized view of the page, visit original site.