My thoughts on Python integration in Excel I submitted in the survey listed on https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10549005-python-as-an-excel-scripting-language
- Git & code reviews & external editors => Open + Save As dialogs MUST support a plain text option, e.g.:
a) the un-zipped directory that currently makes the .xlsm file, or
b) have 2 files .xslx + .xslpy where:
- the excel file would contain a link to the python file similar to "Data > Connections"
- the python file would be plain text: