kk_jd_comment.py 文件源码

def writrProxyExcel(proxyInfo_list):
    pata = '/Users/wangjiacan/Desktop/shawn/????/agentPool.xlsx'
    page_workbook = openpyxl.load_workbook(pata)

    # ???
    page_workbook.remove_sheet(page_workbook.get_sheet_by_name(page_workbook.get_sheet_names()[0]))

    # ???
    new_sheet = page_workbook.create_sheet()

    for i in range(len(proxyInfo_list)):
        new_sheet["A%d" % (i + 1)].value = proxyInfo_list[i]['ip']
        new_sheet["B%d" % (i + 1)].value = proxyInfo_list[i]['??']
        new_sheet["C%d" % (i + 1)].value = proxyInfo_list[i]['????']

    page_workbook.save(pata)