Share via

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

Anonymous
2023-08-28T14:39:51+00:00

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

Microsoft 365 Insider | Program announcements and registration | Windows

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

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-08-29T04:54:20+00:00

    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

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-03-11T18:53:31+00:00

    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
  3. Anonymous
    2023-08-30T06:37:55+00:00
    0 comments