openpyxl文件写入数据

python使用第三方库openpyxl，Excel写入数据

pip install openpyxl

​
from openpyxl import load_workbook

# 加载excel
wb = load_workbook('./data.xlsx')
# 获取excel所有sheet名称
print(wb.sheetnames)
# 指定sheet
sheet = wb['Sheet1']
# 单元格写入数据
sheet['A1'] = 123
sheet['A2'] = 'asdfg'
sheet['A3'] = True
sheet['A4'] = 'asdfg'
# 保存文件
wb.save(filename='data.xlsx')

​