=PY() and desktop path from Python

[Radoslaw Poprawski]

so hello,

I am using beta M365 Excel and I am working on some sort smart solution for some.
What would be great is to get Python code that generates path to a desktop ( or at least Windows username )

My problem is that I tried:

# importing os module
import os
 
 
# using getlogin() returning username
os.getlogin()

and also a defined function:

import os
def get_username_os():
   return os.getenv("USERNAME")
username = get_username_os()
print(f"Current username: {username}")

however it does not work with =PY() excel function.
any idea how can get Desktop path (or windows username at least) with python code?

 

[RoryA]

As you know:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
Python in Excel - get windows username?

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Radoslaw Poprawski]

Hi, is any1 able to help?