2018年06月27日 openpyxl 操作excel 示例 import openpyxlwb = openpyxl.load_workbook('sample.xlsx')ws=wb.activews1=wb.create_sheet("mysheet")ws2=wb.create_sheet("mysheet2",0)ws.title = "New Title"ws.sheet_properties.tabColor = "1072BA"ws3 = wb[