3 - 회사 이름들 가져와서 중복제거

엑셀파일들

 

test.xlsx

0.01MB

result.xlsx

0.01MB

 

 

from openpyxl import load_workbook

read_wb = load_workbook('./test.xlsx', data_only=True)
read_ws = read_wb.active

list1 = []

row = 70

for i in range(2, row) :

    list1.append(read_ws.cell(i, 2).value)

print(list1)

list2 = set(list1)

print(list2)

list3 = list(filter(None, list2))

print(list3)