Python openpyxl

Python openpyxl 追加写入

pip install openpyxl -i https://pypi.douban.com/simple

import openpyxl

excel_bood = openpyxl.Workbook()  # 获得可写入的workbook对象
excel_bood.create_sheet("sheet")  # 创建sheet对象, title="", index=None, title代表sheet名字, index(int)代表sheet的位置(从左往右0,1,2,3....),
excel_table = excel_book.active  # 激活 worksheet
# 写入表头数据
excel_table.cell(1, 1, "用户")
excel_table.cell(1, 2, "用户昵称")
excel_table.cell(1, 3, "用户性别")
for i in ["A", "B", "C"]:
	excel_table.column_dimensions[i].width = 30  # 更改列宽
excel_table.save("account_openpyxl.xlsx")  # sava

# 追加写入数据
excel_appent_book = openpyxl.load_workbook("account_openpyxl.xlsx")  # 获取Excel
excel_appent_table = account_book.active  # 激活 worksheet
excel_appent_table_line = excel_appent_table .max_row  # 获取最大行
print(f"max_column-----最大列-----{excel_appent_table.max_column}")
excel_appent_table.cell(excel_appent_table_line + 1, 1, "1")  # 继续写入数据
excel_appent_table.cell(excel_appent_table_line + 1, 2, "张三") 
excel_appent_table.cell(excel_appent_table_line + 1, 3, "男") 
excel_appent_book .save("account_openpyxl.xlsx")  # 写完记得save