Automate Excel with Python and xlwings Part 1: Install xlwings and the basic HD

Buy Me a Coffee? https://www.paypal.me/jiejenn/5 Your donation will support me to continue to make more tutorial videos! xlwings is an open-source library created by Zoomer Analytics to manipulate Microsoft Excel with Python. In my opinion, xlwings is probably one of the best libraries out there to interact with Excel application beside win32com. Since you can achieve quiet many things with xlwings, I construct the tutorial into multiple series. In part 1 of the tutorial, I will be covering just the basic: 1) How to install xlwings 2) How to create new Excel file & link existing Excel file 3) Write/Read data Part 2: Run Python Function in Excel https://youtu.be/uFJ8wpgoq_E Part 3: Options and Default Converters https://youtu.be/lcSgieqjIpY Part 4: Built-in Converters https://youtu.be/SuzH6vIwJXc My setups: Office 365: https://microsoft.msafflnk.net/xRDq1 Surface: https://microsoft.msafflnk.net/jBAjP Visit my website https://LearnDataAnalysis.org