从excel中提取数据并且连接数据库

• 背景：需要在数据库中查询是否有如下候选人的申请

 

 select * from jobdb.job_application where company_id=61153 and ats_status=3 and update_time >="2022-01-28 00:00:00" and applier_name in ("刘斌斌","刘斌斌","刘斌斌","刘斌斌","刘斌斌","刘斌斌","张可续","覃积","杨晓丹","李观强","李观强","刘崇峻","高冬梅","杨天惠","廖闯立","林明帅","李如凤","YiniPeng","王靖鹏","刘强","蔡洪宁","咸国媛","罗紫昕","汪敏芳","宋鑫雨","罗佳","张晓元","张晓元","于碧琦","冯彦钦","李思澄","李思澄","李思澄","张红梅","金希","于海洋","韦轶","王雨迩","吴祎珏","欧阳志蓉","游卓君")

需要拼接出："刘斌斌","刘斌斌","刘斌斌","刘斌斌","刘斌斌","刘斌斌","张可续","覃积","杨晓丹","李观强","李观强","刘崇峻","高冬梅","杨天惠","廖闯立","林明帅","李如凤","YiniPeng","王靖鹏","刘强","蔡洪宁","咸国媛","罗紫昕","汪敏芳","宋鑫雨","罗佳","张晓元","张晓元","于碧琦","冯彦钦","李思澄","李思澄","李思澄","张红梅","金希","于海洋","韦轶","王雨迩","吴祎珏","欧阳志蓉","游卓君"

• 第一版代码如下：

import xlrd
data_nuohua = xlrd.open_workbook("E:\\MoSeeker China Candi_05Apr_0134—Brassring.xls")
table = data_nuohua.sheet_by_index(0) #用索引获取sheet内容
row = table.nrows #获取sheet中有效行数
list = [8, 9, 10, 11, 12, 13, 20, 31, 75, 172, 173, 174, 204, 209, 348, 364, 365, 388, 429, 445, 449, 510, 515, 524,
        531, 577, 578, 579, 599, 603, 636, 637, 638, 657, 760, 866, 903, 940, 1008, 1039, 1042] #有隐藏的行，手动把行数列出来，待改进
str=""
for i in list:
    row_date = table.row_values(i-1) #获取第i行数据
    str += '"'+row_date[4] + row_date[3]+'"' + "," #用列名获取，待优化；打印的值中尾部多了一个逗号，待优化
print(str)