VS Code Excel VBA集成

Requirements

• VS Code 1.95+
• Python 3.10+ -- the VBA read/write backend runs as a child process
• Python packages: pyOpenVBA >= 3.0.1, openpyxl >= 3.1.0

No COM automation, no Office installation, no win32com -- works on Windows, macOS, Linux, and remote containers.

Nothing else is needed to get the extension up and running. The remaining documentation here is for further development of the XLIDE extension development purposes only.

---

Development setup

```bash git clone https://github.com/WilliamSmithEdward/xlide_vscode.git cd xlide_vscode

Build commands

---

Python side (optional venv)

python -m venv .venv .venv\Scripts\activate # or: source .venv/bin/activate pip install -r python/requirements.txt ```

Press F5 in VS Code to launch an Extension Development Host with the extension loaded and the watch compiler running.

---

Per-workbook export config

Stored beside each workbook as <workbookname>.extension.repo.json:

{
  "exportFolder": "C:/absolute/path/to/export",
  "exportMode": "trueUp",
  "managedFiles": ["Module1.bas", "Sheet1.cls"]
}

trueUp (default) -- replace existing, add new, delete stale files tracked in managedFiles. replaceExistingOnly -- only replaces files already on disk.

---