If you run the code through command line, please run convert_table.py
.
If you are going to compile the code, please use convert_table_v2.spec
.
See the details below.
pip3 install pandas openpyxl
python3 convert_table.py /path/to/excel /output/path
If you input a path, it will scan all the xls
and xlsx
files in the path and convert all of them.
pip3 install pyinstaller
pyinstaller -F convert_table_v2.py
If you input a path, it will scan all the xls
and xlsx
files in the path and convert all of them.
Maybe it is slow to load the process, just wait patiently untile it shows 'Please enter file path'.
No model named 'pkg_resources.py2_warn'
- open
convert_table_v2.spec
- modify
hiddenimports=['pkg_resources.py2_warn']
- compile again
pyinstaller -F convert_table_v2.spec
. Use.spec
instead of.py