Advantages and Disadvantages of OpenPyXL Package
Advantages:
Does not rely on Excel, suitable for software development.
Lightweight and flexible, supports object models, powerful functionality, OpenPyXL + pandas.
Cross-platform.
Disadvantages：
Functionality is not as comprehensive as VBA.
The entire operation process is invisible; results are only visible after saving and reopening.
Cannot directly open .xls files.
Installing OpenPyXL Package:
Online installation: pip install openpyxl
Offline installation: https://pypi.org/project/openpyxl/#files