摘要：
1、修改表格中的内容 1.1 向某个格子中写入内容并保存 from openpyxl import load_workbook workbook = load_workbook(filename="test.xlsx") sheet = workbook.active sheet["A1"] = " 阅读全文
摘要：
1、打开excel表格并获取表格名称 from openpyxl import load_workbook workbook = load_workbook(filename="test.xlsx") print(workbook.sheetnames) #输出 ['Sheet1', 'Sheet2 阅读全文