修改 sheet 表的名称 sheet.title from openpyxl import load_workbook workbook = load_workbook(filename='../data/8.1test.xlsx') sheet = workbook.……

删除行和列 .delete_rows()和.delete_cols() from openpyxl import load_workbook workbook = load_workbook('../data/4.1test.xlsx') sheet = workbook……

向某个格子中写入内容并保存 方式一：直接修改源文件中的单元格 from openpyxl import load_workbook workbook = load_workbook(filename='../data/1.1test……