import pandas as pd

from requests import post

# 读取Excel文件

df = pd.read_excel('trademark_data.xlsx')

# 学工系统API地址

url = 'https://school-system.com/api/trademark'

# 遍历每一行数据并提交

for index, row in df.iterrows():

data = {

主数据管理

'student_id': row['学号'],

'trademark_name': row['商标名称'],

'application_date': row['申请日期']

}

response = post(url, json=data)

print(response.status_code)