#coding:utf-8
import xlrd,requests
file_name = r"F:\pythonScript\map_dp\data_center\data_config\second_disaster_of_agriculture_and_natural_gas.xls"
workbook = xlrd.open_workbook(file_name)
sheet1_name = workbook.sheet_names()[0]
sheet1 = workbook.sheet_by_name('Sheet1')
body = sheet1.cell(1, 8).value.encode('utf-8')
print(body)
url = "http://uatrgm.mapfarm.com/akat/disaster/agrometeo_disaster/all_agrometeo_disaster_list"
headers = {"Authorization": "34qdwwbgf3589xwe2vcf367as4maexvw"}
r = requests.get(url=url,headers=headers,params=body)
print(r.text)