Combine Excel & Python | Execute a Python Script from Excel using xlwings | Works on Windows & macOS

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This video will show how to execute a Python File from Excel using the library xlwings. This solution will work on macOS. Additionally, you could also specify a virtual environment you want to use to execute the Python File.

📝 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀:
Xlwings Troubleshooting page:

Download the Python & Excel file to create the Gantt Chart (as shown in the video):

✅ 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
00:00 | Demo
00:17 | Installation xlwings
00:47 | QuickStart project with add-In
09:00 | Standalone QuickStart project
12:07 | Add xlwings to an existing project
13:54 | Wrap-Up
15:05 | Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?

[CodingIsFun]

*I will be here in the comments section. For any issues, please provide your exact error message, and I will try to help.*

[sigge]

Absolutely loved this, answered most of my questions. Thanks!!

[ojschoolz]

Hello, I'm trying to follow along with your video but i am getting the error "'xlwings' is not recognized as an internal or external command,
operable program or batch file." when trying to quickstart

[automateboringstuffwithraj]

Can we use custom python UDFs in all excel files like xlsx, and unsaved excel files as well?

[mando]

Great video, any suggestions on how to make it so another user doesn't need python to run it on excel?

[GeoteknikIndonesia]

Amazing man. Can I ask u a question. So you show at minutes 9:05 on how to run the script from a folder "script". you define the python path as %%userprofile\dektop\scripts . But if you have to move the whole directory somewhere else, the scripts will not be working right? since the python path is fixed. Is there any way to define the python script relative to the "script" folder but without rechange/readjust the pyhton path again once we move the directory ?

[elinversordepastos]

This content is just EXCELLENT. Thank you very much!

[JITISH]

Hi, thank you for the great tutorial. When I click the Run Main button, why does xlwings close my excel file and delete it from the folder as well?

[calichito]

I just have a question: I have a table in a excel sheet, How i could insert a new row to put data in that new row inserted? Thanks a lot

[saurabhchougule]

Could you please help.

Df = sheet.range('A1').expand().options(pd.Dataframe, index=False).value

This is not taking in the entire data from excel if the first column has blank values. Any workaround to get whole data ?

[me_]

Hi,
thanks for your helpful videos!
The part starting at 12:07 seems to be the one relevant for me at the moment but I’m working with Jupyter Notebooks. I followed your instructions but Excel “Could not find interpreter!“ - can you help?

[DewanshiRamani]

Hello, how to use xlwings server in wsl system step by step instraction

[theDavidJVarela]

I am getting the following error while using macOS and OneDrive: Error Traceback (most recent call last): File "<string>", line 1, in <module> TypeError: 'module' object is not callable. I tried the troubleshooting section of the xlwings page, but it is not obvious to me how to execute some of the troubleshooting sections of the page. I haven't figured out how to Add the directory of your Python source file to the PYTHONPATH—again, either via Ribbon or xlwings.conf sheet. Can someone please help me understand how to address this?

[praveenurugonda]

I have doubt . I created python file in anaconda environment. I can not able to run that code by giving in macro paths only. Can you guide how to run anaconda created python file in macro by giving their paths

[confidential]

Hi, instead of stackoverflow I am heading towards here :P, I got a question, I made in excel a bot with chromedriver which was getting me crypto/stock prices so to calculate my value of my portfolio. But since last it didnt work anymore saying chrome version 95 is not supported by this chromedriver. So I tried to install the latest version..I just replaced the old with the new one..it didn't worked but somehow in the evening all of sudden it did work, but now the fun part..Malwarebytes wanted to do a routine scan ..I said yes and It found malware.heurestic ..so it was a zero day something..so I am not sure now, is it safe to use the latest version of chromedriver, are there any issues with it? I do want a clean system, dont like to get compromised.

[heheh]

after doing the quickstart I get a message bash is a directory. please help!

[mypage]

Hello! Will xlwings work with the Microsoft365 version of Excel?

[slickbuyers]

"xlwings' is not recognized as an internal or external command, " my issue with the addin install

[lockmaboc]

Hi ! Thanks a lot for your video ! It's great ! Maybe you can help me, I followed the same things you have done. First, i don't have any "xlwings" my ribbon, so I added one using : xlwings quickstart demo --addin --ribbon
After that, every time i tried tu run the macro i got an error : Sub not define
And I tried everything i knew it didn't works.

Please can you help me ? In fact i already have a python script that I coded on my Windows Pc and I linked it to an excel file in order to run the code every time I push the button.
I want to do the same on my Macbook and it driving me craizy cause it doesn't works

Please !

[bosco]

I suppose this only woks on Excel 365.