import os
addNum = []
import xlrd
file_path = 'C:/Users/ypj/Desktop/excel/waitdelete.xlsx'
addNum = []
wb = xlrd.open_workbook(file_path)
sheet1 = wb.sheet_by_index(0)
nrows = sheet1.nrows
ncols = sheet1.ncols
for i in range(nrows):
for j in range(ncols):
value = sheet1.cell_value(i, j)
addNum.append(value)
# print(value)
print(addNum)
addNum1 = []
path1 = os.listdir('C:/Users/ypj/Desktop/11/')
path2 = 'C:/Users/ypj/Desktop/11/'
i = 0
while(i < len(addNum)):
path3 = addNum[i] + '.txt'
# print(path3)
addNum1.append(path3)
i += 1
print(addNum1)
j = 0
while(j < len(addNum1)):
for f in path1:
k = 0
if(f == addNum1[j]):
k += 1
print(f)
# print(path2 + f)
os.remove(path2 + f)
if (j % len(addNum1) == 0):
print("已删")
j += 1
print(i)
将一个文件夹里与excel读取的数据相同的删除(Python)
最新推荐文章于 2024-08-31 07:11:56 发布
本文介绍了如何使用Python读取Excel文件,提取数据,并根据数据动态创建文本文件路径,然后遍历这些路径,根据文件名进行匹配并删除。重点展示了文件操作和数据处理的自动化流程。
5万+

被折叠的 条评论
为什么被折叠?



