Python：批量查找Excel文件的特定字符串

#excel文件操作
import xlrd
import os
sheet_name=[]
row_index=[]
col_index=[]
lists=[]
excel_name=[]
ls=os.listdir('d:/Thomson20190623')
for k in ls:
    #print(k)
    excel=r'd:/Thomson20190623/%s'%k
    data=xlrd.open_workbook(excel)
    for sheet in data.sheets():
        for rowidx in range(sheet.nrows):
            row = sheet.row(rowidx)
            #print(row)
            for colidx, cell in enumerate(row):
                if cell.value == "Legal Advisors":
                    sheet_name.append(sheet.name)
                    row_index.append(rowidx)
                    col_index.append(colidx)
                    excel_name.append(k)
for k in range(len(sheet_name)):
    lists.append([excel_name[k],sheet_name[k],row_index[k],col_index[k]])
with open('legal_advisor.txt','w') as f:
    f.write('excel_name,deal_num,row_index,col_index'+'\n')
    for i in lists:
        i=str(i).strip('[').strip(']')
        print(i)
        f.write(i+'\n')