qq_37144341的博客

向一个Excel表格中A1位置插入一张图片。Python实现from openpyxl import load_workbookfrom openpyxl.drawing.image import Imagedef insertimg2excel(imgPath, excelPath): imgsize = (720 / 4, 1280 / 4) # 设置一个图像缩小的比例 wb = load_workbook(excelPath) ws = wb.active

# 饼图from openpyxl import Workbookfrom openpyxl.chart import PieChart, Referencefrom openpyxl.chart.label import DataLabelListfrom openpyxl.chart.text import RichTextfrom openpyxl.drawing.text import Paragraph, ParagraphProperties, CharacterProperties