Automate Excel with Python and xlwings Part 1: The Basic

Apr 9, 2019 | Python, xlwings

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...

Python Virtual Environment For Beginners

Apr 9, 2019 | Python

A Python Virtual Environment in simple definition, is an isolated python development environment. When you are working on a Python project, it is always advised to create a separated Python environment to install the necessary libraries and packages. In this tutorial,...

Display SQL Server Query Result with PyQt5 in Python

Apr 5, 2019 | PyQt5, Python

Sometimes when you receive some really amazing PowerPoint presentation file, and you see some of images you would like to reuse for future presentation but you don’t want to go through the hassle manually save each image one-by-one, and export them to your PC.In...