pip install openpyxl python import openpyxl python wb = openpyxl.load_workbook('file.xlsx') python sheet = wb['Sheet1'] python chart = openpyxl.chart.BarChart() python data = openpyxl.chart.Reference(sheet, min_col=1, min_row=2, max_col=1, max_row=6) chart.add_data(data, titles_from_data=True) python python sheet.add_chart(chart, 'B2') python wb.save('file.xlsx') wb.close()


上一篇:
下一篇:
切换中文