where is main.py ?

[tuanlv14]

Sometime, I would like to edit & manage main.py code in vscode and work with code assisstant like as cline. So where can I fould main.py and open it on my vscode ? Can I select which .py file will be run with an excel workbook ? Can I run multiple .py files under a source folder to help I manager source code better ? I know that xlwing is still in developing. But pls consider. And let me know if some feature is avaiable now. Thank in advance.

[fzumstein]

Hi @tuanlv14, thanks for giving xlwings Lite a try and taking your time to provide feedback!

• You can't connect xlwings Lite with your local installation of VS Code, no. Office Scripts at some point allowed you to connect the online version of Excel with the online version of VS Code, but that feature seems to have been removed again (https://www.reddit.com/r/excel/comments/1d8pnhp/office_script_in_excel_with_vscode_connection/), so it's probably not that easy and therefore not on the roadmap for xlwings Lite.
• main.py is a virtual file that is stored inside the Excel workbook, just like VBA. So your best option is to copy/paste the code into VS Code.
• Adding an AI assistant such as cline is on the roadmap
• Adding support for more than one module is on the roadmap