21/10/2025

Python operation on Excel — How to use openpyxl

1. Introduction In the previous article, we discussed using the combination of xlrd, xlwt, and xlutils to manipulate Excel files. This article continues with another approach: openpyxl. It must be said…

20/10/2025

Python Office Automation with Excel — How to use xlsxwriter

1. Introduction Previously, we discussed the two most common approaches for handling Excel files in Python: xlrd/xlwt and openpyxl. To summarize: This article continues the discussion by exploring other methods for manipulating Excel…

20/10/2025

How to read and write Excel using Python- xlrd and xlwt

1. IntroductionIn our daily work, we frequently use office software such as Word, Excel, PowerPoint, and PDF. However, we often encounter repetitive and tedious tasks, making manual operations highly inefficient….