from collections import OrderedDict
import pandas
import ast
def pandas_excel():
res = pandas.read_excel(r"C:\Users\USER\Desktop\works\all\\Workbook1.xlsx")
# print(res[1])
list_all = []
# print(len(list(set(res["a0"]))))
for j in range(len(res["a1"])):
# for i in range(1,17):
list1 = [res["a0"][j],res["a1"][j],res["a2"][j],res["a3"][j],res["a4"][j],res["a5"][j],res["a6"][j],res["a7"][j],res["a8"][j],res["a9"][j],res["a10"][j],res["a11"][j],res["a12"][j],res["a13"][j],res["a14"][j],res["a15"][j],res["a16"][j]]
list1 = [ str(i) for i in list1]
list_all.append(list1)
# print(list_all)
list_all = [ str(i) for i in list_all]
list_all = list(OrderedDict.fromkeys(list_all))#去重
list_all = [ast.literal_eval(i) for i in list_all]#转列表格式
return list_all
08-12
1860