结果在笔记本里
import numpy as np
import xlrd
import xlutils
data = xlrd.open_workbook('D:/files/审计/2014-2019汇总.xlsx')
key= xlrd.open_workbook('D:/files/审计/关键词.xlsx')
#bk=xlrd.open_workbook('D:/files/审计/2014-2019汇总2.xlsx')
fp=open('D:/files/审计/result.txt','w')
table = data.sheets()[0]
table2 = key.sheets()[0]
nrows=table.nrows #获取行数
keyrow=table2.nrows
print(nrows)
print(keyrow)
for i in range(1,nrows):
row_data=table.row_values(i)
cell_H = table.cell(i,7).value
print(cell_H)
line=''
for j in range(0,keyrow):
cell_A=table2.cell(j,0).value
if cell_H.find(cell_A)!=-1:
line = line + ' ' + cell_A
line=line+ '\n'
fp.write(line)
fp.close()
直接在原表写入
# -- coding: utf-8 --
import numpy as np
import xlrd
import xlwt
import xlutils
from xlutils import copy
data = xlrd.open_workbook('D:/files/审计/2014-2019汇总2.xlsx','w+')
wbook = copy.copy(data)#复制文件并保留格式
w_sheet = wbook.get_sheet(0)#索引sheet表
key= xlrd.open_workbook('D:/files/审计/关键词.xlsx')
table = data.sheets()[0]
table2 = key.sheets()[0]
nrows=table.nrows #获取行数
keyrow=table2.nrows
print(nrows)
print(keyrow)
for i in range(1,nrows):
cell_H = table.cell(i,7).value
#print(cell_H)
line=''
for j in range(0,keyrow):
cell_A=table2.cell(j,0).value
if cell_H.find(cell_A)!=-1:
line = line + ' ' + cell_A
#line=line+ '\n'
w_sheet.write(i,8,line) # 向指定表中第i行j列写入数据m
wbook.save('D:/files/审计/2014-2019汇总2.xlsx')