How can I enable Python in Excel: Combining the power of Python and the flexibility of Excel

Question

How can I enable Python in Excel: Combining the power of Python and the flexibility of Excel

Anonymous

I'm a global admin for our Tenant , how can i enable this feature(Python in Excel: Combining the power of Python and the flexibility of Excel) for some of the users ? Please advise

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Answer 1

Anonymous

Was this ever figured out? I have it on my machine presumably due to some development tools, but I am trying to get this added for some of our standard users and have not been able to track it down.

0 comments

Answer 2

Anonymous

My Query is about https://github.com/microsoft/python-in-excel

0 comments

Answer 3

Hello Krishna,

To enable Python in Excel for some of the users, you can follow these steps:

Install the latest version of Excel and Python on the users' computers.
Enable the Developer tab in Excel by going to File > Options > Customize Ribbon and checking the Developer box.
Click on the Developer tab and then on Excel Add-ins. In the Add-ins dialog box, browse for the xlwings add-in file (xlwings.xlam) and check the box next to it. This file is located in the xlwings folder of your Python installation.
Click OK to close the Add-ins dialog box. You should see a new xlwings tab in Excel.
On the xlwings tab, click on Import Python UDFs. This will import any Python functions that you have defined in a file named xlwings_udfs.py in your current working directory.
You can now use these Python functions in Excel by entering them as formulas, such as =my_function(A1).

Hope this helps!

Fathia