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 in Excel