Python一分钟读写Excel-openpyxl

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)