[已解决]chart插入到excel里

amywong

试过好多种方法，都无法把chart插入到excel，求指点
wb=openpyxl.load_workbook(filename)
ws = wb.sheetnames
chart=LineChart()
chart.title='Result'
chart.x_axis.title='times'
chart.y_axis.title='values'
xvalues=Reference(ws,min_col=1,min_row=2,max_row=40)
yvalues=Reference(ws,min_col=6,min_row=2,max_row=40)
chart.add_data(yvalues,from_rows=True,titles_from_data=False)
chart.set_categories(xvalues)
ws.insert_chart('A60',chart)

最佳答案

月排行榜 / 总排行榜

逃兵

2021-2-1 11:20:50

ws = wb.sheetnames会生成一个列表，这里是错的
改成ws = wb[sheetname] #sheetname是你的工作薄名称
ws.insert_chart('A60',chart)
改为ws.add_chart(chart, "A60")

例子：

1. import openpyxl
   
2. from openpyxl.chart import (
   
3.     LineChart,
   
4.     Reference,
   
5. )
   
6. filename = 'test.xlsx'
   
7. wb=openpyxl.load_workbook(filename)
   
8. sheetname = 'Sheet1'
   
9. ws = wb[sheetname]
   
10. chart=LineChart()
    
11. chart.title='Result'
    
12. chart.x_axis.title='times'
    
13. chart.y_axis.title='values'
    
14. xvalues=Reference(ws,min_col=1,min_row=2,max_row=40)
    
15. yvalues=Reference(ws,min_col=6,min_row=2,max_row=40)
    
16. chart.add_data(yvalues,from_rows=True,titles_from_data=False)
    
17. chart.set_categories(xvalues)
    
18. ws.add_chart(chart, "A1")
    
19. wb.save('test.xlsx')
    

复制代码

跳转到最佳答案楼层

逃兵

ws = wb.sheetnames会生成一个列表，这里是错的
改成ws = wb[sheetname] #sheetname是你的工作薄名称
ws.insert_chart('A60',chart)
改为ws.add_chart(chart, "A60")

例子：

1. import openpyxl
   
2. from openpyxl.chart import (
   
3.     LineChart,
   
4.     Reference,
   
5. )
   
6. filename = 'test.xlsx'
   
7. wb=openpyxl.load_workbook(filename)
   
8. sheetname = 'Sheet1'
   
9. ws = wb[sheetname]
   
10. chart=LineChart()
    
11. chart.title='Result'
    
12. chart.x_axis.title='times'
    
13. chart.y_axis.title='values'
    
14. xvalues=Reference(ws,min_col=1,min_row=2,max_row=40)
    
15. yvalues=Reference(ws,min_col=6,min_row=2,max_row=40)
    
16. chart.add_data(yvalues,from_rows=True,titles_from_data=False)
    
17. chart.set_categories(xvalues)
    
18. ws.add_chart(chart, "A1")
    
19. wb.save('test.xlsx')
    

复制代码

amywong

wb = openpyxl.load_workbook(path + "\\Result.xlsx")
ws=wb.create_sheet(‘sheet’)
chart=LineChart()
chart.title='Result'
chart.x_axis.title='times'
chart.y_axis.title='Values'
xvalues=Reference(ws,min_col=1,min_row=2,max_row=ws.max_row)
yvalues=Reference(ws,min_col=2,min_row=2,max_row=ws.max_row)
chart.add_data(yvalues,from_rows=True,titles_from_data=False)
chart.set_categories(xvalues)
ws.add_chart(chart,'G2')

这样操作没有报错，但是图表没有加到excel ，求指导

逃兵

amywong 发表于 2021-2-1 19:21
wb = openpyxl.load_workbook(path + "\\Result.xlsx")
ws=wb.create_sheet(‘sheet’)
chart=LineChart( ...

操作完以后保存文件了吗
wd.save(path + "\\Result.xlsx")