qq_44976861的博客

excel 相关操作自动办公之表格计算及生成条形图导入openpyxl模块（pypi官网复制pip指令下载）import openpyxl as xlfrom openpyxl.chart import BarChart,Referencewb = xl.load_workbook("test.xlsx")sheet = wb['Sheet1']#访问单元格#cell = sheet['a1']# cell = sheet.cell(1,1)for row in range(2,sh