calling user environment variables from xlwings script

[notacoat]

Cannot load variables from my bash profile. This works in python outside of xlwings.

syntax I'm using is

'user': os.environ['USERNAME']
'passwd': os.environ['PASSWORD']

[fzumstein]

yes, that's right - from Excel it calls python in the terminal directly without loading your bash_profile. Let me think about a solution/workaround...

[fzumstein]

Great catch! This is resolved now and will be included in the next release - if you want it now, just replace the VBA module with this here: https://github.com/ZoomerAnalytics/xlwings/blob/master/xlwings/xlwings.bas

This change also means that the default path from .bash_profile is now finally used as interpreter on Mac if PYTHON_MAC = "".