1. 需求:
(1)导出数据age列如果大于27,设置背景色并且字体红色
(2)导出数据love列如果包含关键字basketball,设置字体为红色
(3)导出数据comments列如果包含关键字American,设置背景色,字体为蓝色
2. 导出效果:
import re
import pandas as pd
def export_ms_excel():
data = [{'name': 'Jalen',
'age': 28,
'love': '1.read book.<br>2.play game.<br>3.walking',
'comments': 'from China!'},
{'name': 'Mercy',
'age': 28,
'love': '1.play <span style="color:red">basketball</span>.<br>2.read book.<br>3.travel',
'comments': 'from American!'},
{'name': 'Abely',
'age': 26,
'love': '1.read book.<br>2.play game.',
'comments': 'from Australia!'},
{'name': 'Jermy',
'age': 28,
'love': '1.read book.<br>2.play <span style="co