May 3, 2020

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

Buy Me a Coffee? 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... Read More

Buy Me a Coffee?
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

Part 3: Options and Default Converters

Part 4: Built-in Converters

Part 5: Access the Missing Features

Visit my website

Considering support my channel through shopping on Amazon

Want to be more productive? Check out the the gear (Amazon affiliate links) I use when I am working.
Lenovo ThinkPad X1 Extreme 2nd Gen (4K):
ASUS Designo Curve MX38VC 37.5″ Monitor:
Logitech MX Master 3 Advanced (My primary mouse):
Logitech MX Anywhere 2S (When traveling):
Logitech Craft Advanced Wireless Keyboard:
VAVA USB C Hub, 8-in-1 USB C Adapter :
Theralite Aura Bright Light Therapy Lamp:

Nguồn: https://valiosys.com

Xem thêm bài viết khác: https://valiosys.com/cong-nghe