import requests
from xml.etree import ElementTree as ET
from openpyxl import load_workbook
from openpyxl import workbook
from openpyxl.styles import Alignment, Border, Side, Font, PatternFill, GradientFill
work_book_01 = workbook.Workbook()
# del work_book_01['sheet'] 报错:KeyError: 'Worksheet sheet does not exist.'
count = 0
while True:
city = input("请输入城市(Q/q退出):")
if city.upper() == "Q":
break
url = "http://ws.webxml.com.cn//WebServices/WeatherWebService.asmx/getWeatherbyCityName?theCityName={}".format(city)
res = requests.get(url=url)
file = ET.XML(res.text)
sheet_01 = work_book_01.create_sheet(city,count)
sheet_01.column_dimensions["A"].width = 50
for rows,i in enumerate(file,1):
text = i.text
cell = sheet_01.cell(rows,1)
cell.alignment = Alignment(horizontal='center', vertical='center', text_rotation='0', wrap_text=True)
cell.font = Font(name='新宋体',size='12',color='990000',underline='single')
cell.value = text
count += 1
work_book_01.save('tianqi.xlsx')
# 问题:多了一个空白的sheet怎么处理