from openpyxl import load_workbook
workbook = load_workbook(filename='E:\\工作表.xlsx')
sheet = workbook.active
#修改某格子的值
sheet['A1'] = '你好啊123'
#按行插入值
data = [
[1, 'a'],
[2, 'b'],
[3, 'c'],
[4, 'd'],
]
for row in data:
sheet.append(row)
#保存修改内容
workbook.save(filename='E:\\工作表.xlsx')
python3 ---Excel表格操作(2)
最新推荐文章于 2022-01-24 12:03:09 发布