As much as Excel is a blessing, it is also a curse. When it comes to smallish enough data and simple enough operations Excel is king. Once you find yourself endeavoring outside of those zones however, it becomes a pain. Sure enough, you can use Excel VBA to get around such issues, but in the year 2020, you can thank your lucky stars because you don’t have to!
If only there was a way to integrate Excel with Python to give Excel… wings! Well, now there is. A python library called xlwings allows you to call Python scripts through VBA and pass data between the two.
In this post. you’ll learn How to Integrate Python and Excel with xlwings
#python #excel #xlwings