Python xlwt写excel自定义函数出错（求大神指点）

最新推荐文章于 2024-05-15 11:50:31 发布

桔科

最新推荐文章于 2024-05-15 11:50:31 发布

阅读量509

点赞数 1

文章标签： python

本文链接：https://blog.csdn.net/hangmai/article/details/103846051

版权

#Python xlwt写excel自定义函数出错（求大神指点）
在这里插入图片描述

import xlwt
import requests
import re

url= 'https://www.zhipin.com/job_detail/?query=AI+%E9%94%80%E5%94%AE&city=101280600&industry=&position='
header={
    "cookie":"lastCity=101280600; __zp_stoken__=67f6083w5gnBqqyQQeu6F2epsweqMkPB4lcM6VYpNwhSdywDoddHnldmNNtNS0BUndK7ykrh4s2PP0Akk4bI0PBLTg%3D%3D; Hm_lvt_194df3105ad7148dcf2b98a91b5e727a=1567920262,1567944309; __c=1567944310; __g=-; __l=l=%2Fwww.zhipin.com%2F&r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DOzvOjn0FdWgdCvGgeFtlZs3fep3S7QAHRxumK4yl6ZUHgkm-gY7aOl3RlZQvWabq%26wd%3D%26eqid%3Dd9fc916500211f40000000065d74ee5f&friend_source=0&friend_source=0; __a=4372309.1567920260.1567920344.1567944310.18.3.7.18; Hm_lpvt_194df3105ad7148dcf2b98a91b5e727a=1567957311",
    "user-agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 Safari/537.36"
}

response=requests.get(url,headers=header).text

jobs=re.findall('<div class="job-title">(.*)</div>',response)

salary=re.findall('<span class="red">(.*)</span>',response)
company=re.findall('<h3 class="name"><a href="/.*" ka="search_list_company_.*_custompage" target="_blank">(.*)</a></h3>',response)



jobs_data=list(zip(jobs,salary,company))

print(jobs_data)

def save_to_excel(doc_save_path, sheet_name, data):
     f = xlwt.Workbook()
     sheet = f.add_sheet(sheet_name, cell_overwrite_ok=True)
     for row, row_data in enumerate(data):
         for column, column_data in enumerate(row_data):
             assert isinstance(sheet.write, object)
            sheet.write(row, column, str(column_data))
     f.save(doc_save_path + ".xls")

 save_to_excel('jobs_list','sheet1','jobs_data')