工欲善其事

手动录入是不可能的，尤其是录入一批东西！

python是一种脚本语言而且写点小东西非常的方便，比如下面这个通过读取xlxs文件中的数据插入到数据字典中的例子。就非常方便省时也省力了！

import openpyxl
import requests

# 打开Excel文件
wb = openpyxl.load_workbook('D:/WorkSpace/python/file.xlsx')
url = "http://ui.system.dev.snpit.com:8911/api/system/dict/data/add"
token = "Bearer eyJhbGciOiJIUzUxMiJ9.eyJ1c2VyX2NvZGUiOiJzbnBpdCIsInVzZXJfaWQiOiIxNzE2NzI0NzgwNzc3NjYwNDE4IiwiYXV0aF90b2tlbiI6IjQ5Y2Y4NzMzNzE1ZTRiYjk4ZGQwNWFkZjZkNzg2MjJmIn0.uckB5mjUy0vtmijT4429g1odHUZ7EkJUvJO27klJmfclymjERdTvdg4DEXtjEPXrJP3JNYQoYXhHphJdhgz0_g"
# 选择工作表
ws = wb.active
# 循环遍历行
for r in ws.iter_rows(values_only=True):
    # 循环遍历单元格
    jsonBody = {"dictType":"consumable_purchasing_units","dictLabel":r[1],"dictValue":r[0],"dictSort":int(r[2])}
    print(jsonBody)
    res=requests.post(url,headers={"Authorization":token},json=jsonBody)
    print(res.text)

# 关闭Excel文件
wb.close() 
print()