How to merge multiple Excel files in Python
In this tutorial, we’ll learn how to merge multiple Excel files in Python. The “merge” operation refers to combining files[…]
Read more
Category: Office Automation
We provide a series of tutorials on how to automate office tasks such as data manipulation in Excel, sending Outlook emails, or creating Word documents.
Use Python To Send WhatsApp Message
Not everyone checks email regularly so we are also going to use Python to send Whatsapp messages to ourselves when[…]
Read morePython Xlsxwriter Create Excel Part 4 Conditional Formatting
The Python xlsxwriter library is capable of creating all sorts of conditional formatting for our Excel file. Let’s take a[…]
Read morePython Xlsxwrite Create Excel Part 3 (Format, Sparkline & Chart)
Building upon our previous file, we’ll use Python xlsxwriter library to beautify our boring-looking Excel spreadsheet by adding formatting, sparkline,[…]
Read morePython Xlsxwriter Create Excel Part 2 (Formula, Link & Named Range)
Xlsxwriter is a powerful library that can recreate most of the features of Excel, including formula, link, and named range.[…]
Read moreUse Python Xlsxwriter To Create Excel Spreadsheet
In this tutorial, we’ll use Python to create a high-fidelity Excel spreadsheet. “High-fidelity” means that the Python-generated Excel spreadsheet will[…]
Read moreHow To Connect And Work With SQLite Database Using Python sqlite3
Today we’ll talk about how to connect and work with the SQLite database using Python. In case you have never[…]
Read moreReplicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)
Excel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]
Read moreSave Python plots into Excel file
We briefly talked about how to create a graph in Python using web data, but it’s not so useful if[…]
Read moreFind and replace Excel data using Python
Today we’ll learn how to replicate a common Excel task – find and replace data in Python. This tutorial is[…]
Read more