import pandas as pd
import json
  
# 读取Excel文件
df = pd.read_excel('example.xlsx') 

# 转换为字典类型
data_dict = df.to_dict()

# 处理字典格式
output = []
for i in range(len(data_dict['Column1'])):
    output.append({data_dict['Column1'][i]: data_dict['Column2'][i]})

# 转换为JSON格式
json_output = json.dumps(output)

# 打印结果
print(json_output)

  Line 4
SyntaxError: Non-ASCII character '\xe8' in file t.py on line 4, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details