ConvertTable

Note:

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.

Reqirment

pip3 install pandas openpyxl

Run

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.

Complie

pip3 install pyinstaller

pyinstaller -F convert_table_v2.py

Double click this file to run

Follow the hint to enter path

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'.

Issues

No model named 'pkg_resources.py2_warn'

  1. open convert_table_v2.spec
  2. modify hiddenimports=['pkg_resources.py2_warn']
  3. compile again pyinstaller -F convert_table_v2.spec. Use .spec instead of .py