jdShopComment.py 文件源码

def readExcel(proxyInfo_list):
    """
    ???????IP
    """
    pata = '/Users/wangjiacan/Desktop/shawn/????/agentPool.xlsx'
    page_workbook = openpyxl.load_workbook(pata)
    page_sheet = page_workbook.get_sheet_by_name(page_workbook.get_sheet_names()[0])
    for row in page_sheet.rows:
        proxyData = {'ip': '', '??': '', '????': '', }
        ip = row[0].value
        httpType = row[1].value
        checkDtime = row[2].value

        proxyData["ip"] = ip
        proxyData["??"] = httpType
        proxyData["????"] = checkDtime

        proxyInfo_list.append(proxyData)
    page_workbook.save(pata)