xlrd 读取列，并排序去重

import xlrd

rpath = r'E:\原始文件.xlsx'
wpath=  r"E:\中间数据_out.csv" #可不用
wpath1=  r"E:\结果_out.txt"

f = open(wpath, "w", encoding='utf-8')
f1 = open(wpath1, "w", encoding='utf-8')

lines_seen = set()
workbook = xlrd.open_workbook(rpath)
for e in workbook.sheets():
    for r in range(e.nrows):
        str_temp = str(e.cell_value(r, 3)).strip()
        if str_temp == '':
            pass
        elif str_temp not in lines_seen:
            f.write("行号，"+str(r+1)+"，"+str_temp+'\n')
            lines_seen.add(str_temp)
f.close()
print("初步处理完成")

lines_seen = sorted(lines_seen)
for str_temp in lines_seen:
    f1.write(str_temp + '\n')
f1.close()

print("处理完成")