from pyecharts import options as opts
from snapshot_selenium import snapshot as driverdef draw_chart(self, file, save_path):"""前端回放性能用例数据统计图file: excel完整路径save_path: html 和 png 保存目录"""data = pandas.read_excel(file, engine='openpyxl')shape = data.shapenrows = shape[0]ncols = shape[1]# print(f'当前总计行数：' + str(nrows))  # 获取行数# print(f'当前总计列数：' + str(ncols))  # 获取列数dt_dates = []  # 日期dt_avg_fpss = []  # 平均帧率dt_fat_fps_nums = []  # 肥胖帧个数for i in range(nrows):dt_date = data.iloc[i, 0]dt_dates.append(dt_date)dt_avg_fps = data.iloc[i, 1]dt_avg_fpss.append(float(dt_avg_fps))dt_fat_fps_num = data.iloc[i, 2]dt_fat_fps_nums.append(float(dt_fat_fps_num))# print(dt_fat_fps_nums)line = (Line(init_opts=opts.InitOpts(width='1850px', height='640px')).add_xaxis(dt_dates).add_yaxis("平均帧率", dt_avg_fpss).add_yaxis("肥胖帧个数", dt_fat_fps_nums).set_global_opts(title_opts=opts.TitleOpts(title="前端性能测试情况")))line.set_series_opts(markpoint_opts=opts.MarkPointOpts(data=[opts.MarkPointItem(type_='average', name='平均值'),opts.MarkPointItem(type_='max', name='最大值'),opts.MarkPointItem(type_='min', name='最小值')]))# 设置标题等line.set_global_opts(title_opts=opts.TitleOpts('前端性能跟踪变化曲线'),# 显示工具箱toolbox_opts=opts.ToolboxOpts(),xaxis_opts=opts.AxisOpts(axislabel_opts={"rotate": 45, "interval": 0}))file_name = self.getTestCaseName(file)html_name = file_name + ".html"html_save_path = save_path + "\\" + html_nameline.render(html_save_path)snapshot_save_path = save_path + "\\bar.png"# 需要安装 snapshot-selenium 或者 snapshot-phantomjsmake_snapshot(driver, line.render(), snapshot_save_path)# webbrowser.open(html_name)