python自动化办公（第8课）向excel表格中写入内容

python自动化办公（第8课）向excel表格中写入内容

• 如果工作表已经被打开，则程序不被允许对表文件进行修改

- 向某个格子写入内容并保存

• sheet[“A1”] = “你好啊”
• cell.value = “你好啊”
• 做完要记得save

from openpyxl import load_workbook # 加载工作表
workbook = load_workbook(filename="新建表.xlsx")
sheet = workbook.active
sheet["A1"] = "你好啊"
workbook.save(filename = "新建表.xlsx")

from openpyxl import load_workbook
workbook = load_workbook(filename="新建表.xlsx")
sheet = workbook.active
cell = sheet["B1"]
cell.value = "你好啊"
workbook.save(filename = "新建表.xlsx")

- 向列表数据插入一行内容

• sheet.append(python列表)

workbook = load_workbook(filename="新建表.xlsx")
sheet = workbook.active
data = [
    ["张三",1],
    ["刘二",2],
    ["王五",3],
    ["李四",4],    
]
for row in data:
    sheet.append(row)
workbook.save(filename="新建表.xlsx")

- 插入一列

• .insert_cols(idx=数字编号)
• 在idx列左边插入一列
• amount=n 是插入多少列

workbook = load_workbook(filename="新建表.xlsx")
sheet = workbook.active
sheet.insert_cols(idx=2)
workbook.save(filename=