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)