python获取天气保存到excel里

import requests
from bs4 import  BeautifulSoup
from openpyxl import Workbook

headers = {
   
            'Connection': 'keep-alive',
            'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0',
            'Accept': 'image/webp,image/*,*/*;q=0.8',
            'Accept-Language': 'zh-CN,zh;q=0.8'
            }
add = {