import pandas as pd
import json
# pd.read_excel()
df = pd.read_excel("123.xlsx",header=None)
print(df)
nested_dict = df.to_dict()
flat_dict = {v[0]: v[1] for _, v in nested_dict.items()}
print(flat_dict)
#


with open("data.json", "w", encoding='utf-8') as f:
   # f.write(flat_dict)
    json.dump(flat_dict, f, ensure_ascii=False)
# import pandas as pd
# import json
#
# # 读取Excel文件
# df = pd.read_excel("附件1-装箱数据.xlsx", sheet_name="订单数据", usecols="B:E", skiprows=1, nrows=10000)
#
# # 将DataFrame转换为字典
# data = df.to_dict(orient='records')
#
# # 存储成json格式
# with open('order_data.json', 'w', encoding='utf-8') as f:
#     json.dump(data, f, ensure_ascii=False)