python excel文件对比并高亮展示
时间: 2023-07-21 14:21:48 浏览: 69
要实现Python中的Excel文件对比并高亮展示,你需要以下几个步骤:
1. 安装必要的库:`pandas`、`openpyxl`
```
pip install pandas
pip install openpyxl
```
2. 读取Excel文件
```
import pandas as pd
df1 = pd.read_excel('file1.xlsx', sheet_name='Sheet1')
df2 = pd.read_excel('file2.xlsx', sheet_name='Sheet1')
```
3. 对比两个Excel文件
```
diff = df1.compare(df2)
```
4. 高亮展示不同之处
```
def highlight_diff(val):
color = 'yellow' if val else 'white'
return f'background-color: {color}'
diff.style.applymap(highlight_diff)
```
完整的代码示例:
```
import pandas as pd
def highlight_diff(val):
color = 'yellow' if val else 'white'
return f'background-color: {color}'
df1 = pd.read_excel('file1.xlsx', sheet_name='Sheet1')
df2 = pd.read_excel('file2.xlsx', sheet_name='Sheet1')
diff = df1.compare(df2)
diff.style.applymap(highlight_diff)
```