NhacVibe
Ảnh bìa Combine Excel & Python | Execute a Python Script from Excel using xlwings | Works on Windows & macOS

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

Sven Bosau · 42,7 N lượt xem · 31 thg 7, 2021

Mô tả

👉 Learn Excel Automation with Python: https://yt.pythonandvba.com/iIATJtruZ...

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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:
► https://docs.xlwings.org/en/stable/tr...

Download the Python & Excel file to create the Gantt Chart (as shown in the video):
► https://yt.pythonandvba.com/iIATJtruZ...

✅ 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
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


𝗠𝗢𝗥𝗘 𝗙𝗥𝗢𝗠 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🧰 My Excel add-ins and Windows apps: https://yt.pythonandvba.com/iIATJtruZ...
🔗 LinkedIn:   / sven-bosau  
📬 Contact: https://yt.pythonandvba.com/iIATJtruZ...