小尹学python

导航

Python:xml文件获取解析并写入进excel案例

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怎么处理

posted on 2021-10-09 16:09  小尹学python  阅读(388)  评论(0编辑  收藏  举报