xlsxwriter+图表

import xlsxwriterworkbook = xlsxwriter.Workbook('chart.xlsx')#创建xlsx文件worksheet = workbook.add_worksheet()#创建表sheet1chart = workbook.add_chart({'type': 'column'})#创建图表对象title = ['name', 'mon', 'tues', 'wed', 'thurs', 'fri', 'sat', 'sun', 'avg']buname = ['1', '2', '3', '4', '5']data = [[12,3,4,5,32,43,43],[32,43,24,23,12,65,43],[65,76,32,12,32,43,33],[34,46,57,21,23,33,22],[11,22,33,44,55,66,77],]format = workbook.add_format()format.set_border(1)#表格线条加粗1format_title = workbook.add_format()format_title.set_border(1)format_title.set_bg_color('#cccccc')#定义背景色format_title.set_align('center')#文本格式居中format_title.set_bold()#加粗format_ave = workbook.add_format()format_ave.set_bold(1)format_ave.set_num_format('0.00')#设置显示格式worksheet.write_row('A1', title, format_title)worksheet.write_column('A2', buname, format)worksheet.write_row('B2', data[0], format)worksheet.write_row('B3', data[1], format)worksheet.write_row('B4', data[2], format)worksheet.write_row('B5', data[3], format)worksheet.write_row('B6', data[4], format)def chart_series(cur_row):worksheet.write_formula('I' + cur_row, '=AVERAGE(B' + cur_row + ':H' + cur_row + ')', format_ave)#计算平均值chart.add_series({'categories': '=Sheet1!$B$1:$H$!',#设置x轴标签'values': '=Sheet1!$B$' + cur_row + ':$H$' + cur_row,#设置数据区域'line': ({'color': 'black'}),#设置线条颜色'name': '=Sheet1!$A$' + cur_row,#图例名称})for row in range(2, 7):chart_series(str(row))#将2到6行进行制表chart.set_size({'width': 577, 'height': 287})#设置表的大小chart.set_title({'name': 'week'})#设置表名称chart.set_y_axis({'name': 'Mb/s'})#设置y轴的小标题worksheet.insert_chart('A8', chart)#将图表插入到A8workbook.close()