python对excel表中数据进行匹配并写入

最新推荐文章于 2025-03-27 13:47:06 发布

姽婳一方

最新推荐文章于 2025-03-27 13:47:06 发布

阅读量8.3k

点赞数 3

分类专栏：编程语言

本文链接：https://blog.csdn.net/weixin_40799076/article/details/89161335

版权

编程语言专栏收录该内容

19 篇文章

订阅专栏

结果在笔记本里

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')