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.
There are some Excel methods and properties xlwings does not support right out the box, to access the missing methods and properties, we have to use a property called “api”. The api property is a pywin32 wrapper around the Excel object model. In this tutorial I will provide few examples how to use xlwings api property to access the missing Excel objects and properties.