ECConverter

A GUI Excel-to-python-code converter.

Prerequisites

• Git 2.32 (or more recent)
• Python 3.11.0 (or more recent)

Setup Development Environment

Recommended IDE: Visual Studio Code

To setup Development Environment, run the following commands:

# git clone this repository
cd QtQuickPythonTemplate
# create venv
python3 -m venv .venv
# activate venv
source .venv/bin/activate
# for Windows Command Prompt, run the following command to activate venv
# .venv\Scripts\activate.bat
# for Windows Powershell, run the following command to activate venv
# .venv\Scripts\Activate.ps1
# for Winows Git Bash, run the following command to activate venv
# source .venv/Scripts/activate

# install site-packages
pip3 install -r requirements.txt
# generate snake_case and true_property pyi for VSCode
pyside6-genpyi all --feature snake_case true_property
# deactivate venv
deactivate
# open current folder using VSCode
code .

After opening the folder, install the following extensions:

• ms-python.python
• ms-python.vscode-pylance
• seanwu.vscode-qt-for-python
• esbenp.prettier-vscode
• Gruntfuggly.triggertaskonsave

These extensions have been written in .vscode/extensions.json, you can also click Yes when VSCode ask you whether to install the recommended extensions, which makes it easier to install all the above extensions.

The next step is to select the interpreter under .venv folder as the development interpreter. Simply press Ctrl + Shift + P, then enter Python: Select Interpreter command.

Finally, press F5. The application should be launched in debug mode.

Deployment

The major 3 operate systems: Windows, MacOS, Linux(Ubuntu / Debian), is supported.

To deploy the application, simply press Ctrl + P in VSCode, then enter task Deploy(Release). If the task is performed successfully, the application will be deployed under: ${workspaceFolder}/deployment/dist.

See spec files under ${workspaceFolder}/deployment/spec for more information.