1. 写Excel
from openpyxl import Workbook
# 创建一个 workbook
wb = Workbook()
# 获取被激活的 worksheet
ws = wb.active
# 1. 设置单元格内容
ws['A1'] = 42
# 2. 按行列
cell = ws.cell(row=1, column=2)
cell.value = "按行列设置值"
# 3. 设置一行内容,跟在最新设置的单元格后面
ws.append([1, 2, 3])
# 保存 Excel 文件
wb.save("sample.xlsx")
2. 读Excel
from openpyxl import load_workbook
wb = load_workbook('./sample.xlsx')
ws = wb.active
print(ws['A1'].value)
print(ws['E5'].value)
# 读取所有的行
for row in ws.rows:
print(row)
# 读取每行单元格内容
for cell in row:
print(cell.value)