import re
import requests
import xlwt
import time
import xlrd
start = time.time()
a = 1
b = 0
list1 = []
list2 = []
EveData_book = xlrd.open_workbook(r'F:\下载文件\evedata.xls')
EveData_sheet = EveData_book.sheet_by_index(0)
row = int(EveData_sheet.nrows)
for n in range(0, 8200):
value_a = str(int(EveData_sheet.cell_value(a, b)))
print(value_a)
list1.append(value_a)
value_b = EveData_sheet.cell_value(a, b + 1)
list2.append(value_b)
a = a + 1
dict = dict(zip(list2, list1))
step1 = time.time()
excel_eve = xlwt.Workbook(encoding="utf-8")
sheet_eve = excel_eve.add_sheet("单价")
a = 3
b = 2
for key in dict.keys():
url = "https://www.ceve-market.org/api/market/region/10000002/type/" + dict[key] + ".xml"
i = requests.get(url)
i = i.text
price_list = re.findall('<min>(.*?)</min>', i)
price = price_list[2]
sheet_eve.write(a, b, key)
sheet_eve.write(a, b+1, price)
a = a + 1
excel_eve.save('F:\eve市场.xls')
end = time.time()
print(step1 - start)
print(end - start)