文件操作作业二,用户输入城市,获取这个城市的天气
'''
2、用户输入城市,获取这个城市的天气
'''
import os
import requests
from xml.etree import ElementTree as ET
from openpyxl import workbook
base_dir = os.path.dirname(os.path.abspath(__file__))
db_file_path = os.path.join(base_dir,'weather.xlsx')
wb = workbook.Workbook()
del wb['Sheet']
while True:
city = input('输入想要查询的城市:')
if city.upper() == 'Q':
break
url = 'http://ws.webxml.com.cn/WebServices/WeatherWebService.asmx/getWeatherbyCityName={}'.format(city)
res = requests.get(url=url)
print(res.text)
root = ET.XML(res.text)
sheet = wb.create_sheet(city)
for row_index,node in enumerate(root,1):
text = node.text
cell = sheet.cell(row_index,1)
cell.value = text