此代码无效,只是学习一下xlwt的使用

最新推荐文章于 2023-11-07 17:12:42 发布

原创最新推荐文章于 2023-11-07 17:12:42 发布 · 303 阅读

CC 4.0 BY-SA版权


## 此代码无效,只是学习一下xlwt的使用

import requests
import xlwt
import time


headers = {
    'Cookie':'54005c3644',
    'Referer': 'httom/',
    'User-Agent':'Mozilari/537.36'
}

def getJobList(page):
    data = {
        'first':'true',
        'pn':page,
        'kd':'pyon'
    }

    res = requests.post("https://www.bs/list_ponlabelWordnput=",data=data,headers=headers)
    result = res.json()
    jobs = result['content']['positionResult']['result']
    return jobs

excell = xlwt.Workbook()

sheet1 = excell.add_sheet("lxxxxxu",cell_overwrite_ok=True)

sheet1.write(0,0,'comnyFullName')
sheet1.write(0,1,'cmpanySize')
sheet1.write(0,2,'potionName')
sheet1.write(0,3,'saary')

n = 1

for page in range(1,30):
    print (page)
    for job in getJobList(page):
        print(job)
        sheet1.write(n, 0, job['comllName'])
        sheet1.write(n, 1, job['conySize'])
        sheet1.write(n, 2, job['poionName'])
        sheet1.write(n, 3, job['sary'])
        n += 1

    time.sleep(1)

excell.save("laider.xls")