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")
- 向列表数据插入一行内容
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=