import   pandas
excel=pandas.read_excel(r'E:\pandas练习\成绩单.xlsx')
b=excel.style.bar(color='orange',subset=['test_1','test_2','test_3'])
b.to_excel()