sdgpcc2000的博客

import openpyxlfrom openpyxl.styles import Fontfrom openpyxl.styles import colors #颜色from openpyxl.styles import Alignment #对齐from openpyxl.styles import Side,Border #边框from openpyxl.styles import PatternFill,GradientFill #填充imp

图表引用openpyxl.chart[Barchart]图表 和[Reference]参考 模块 思路Created with Raphaël 2.3.0创建图表设置标题创建数据图表定位sheet.add_chart(chart,"e2")values=Reference(sheet,min_col=1,min_row=1,max_row=10,max_col=1)chart.title="图表标题" chart.x_axis.title="时间" chart.y_axis.title="数量"

把列表里面的文字 接起来san="A"for i in ["b","c","d"]: san+=iprint(san)Abcdsan="A"for i in ["b","c","d"]: san+="-"+iprint(san) A-b-c-dshan="0"for i in range(1,10):