openpyxl介绍 ：一个用于读写Excel 2010 xlsx/xlsm 文件的python 库

作者：Eric Gazoni, Charlie Clark
源代码：https://foss.heptapod.net/openpyxl/openpyxl
版本信息：https://openpyxl.readthedocs.io/en/stable/changes.html

 pip install openpyxl

文件中如果包含图片（jpeg, png, bmp,…），需要安装“pillow”库

pip install pillow

https://pypi.org/project/Pillow/

from openpyxl import Workbook

workbook = Workbook()
sheet = workbook.active

sheet["A1"] = "hello"
sheet["A2"] = "world!"

workbook.save(filename="hello_world.xlsx")

from openpyxl import load_workbook

workbook = load_workbook(filename="hello_world.xlsx")
print(workbook.sheetnames)

sheet = workbook.active
print(sheet.title)
print(sheet["A1"])
print(sheet["A2"])
print(sheet["A1"].value)
print(sheet["A2"].value)

.cell()

sheet.cell(row=1, column=1)
sheet.cell(row=1, column=1).value

参考资源：
https://openpyxl.readthedocs.io/en/stable/
https://realpython.com/openpyxl-excel-spreadsheets-python/