import pandas as pd import json

读取Excel表格

df = pd.read_excel('123qwe.xlsx')

读取一列数据

column_data = df['menu_id'].tolist() # 将该列数据转化为数组类型

存储数据到json中

data = {'menu_id': column_data} with open('data.json', 'w') as file: json.dump(data, file)