2021-07-05python记录

File contains no valid workbook part

原因：用openpyxl 模块读取了xls格式的excel,或者读取的是xls文件通过改变后缀变成xlsx格式的文件

解决：重新创建xlsx的文件

原因：TypeError: an integer is required (got type bytes)

解决：pip install https://github.com/pyinstaller/pyinstaller/archive/develop.tar.gz

           pip install https://github.com/pyinstaller/pyinstaller/archive/develop.tar.gz

1原因：import openpyxl

1解决：直接cmd:  pip  install openpyxl

2原因：from PIL import ImageFont

2解决：pip install Pillow

3原因：import cv2

3解决：pip install opencv-python

4安装：pip install pyinstaller

4生成exe：pyinstaller -F 2.py   pyinstaller -v