6 - 데이터 엑셀에서 읽기

 

# 엑셀을 읽기 위한 준비과정들
from openpyxl import load_workbook

read_wb = load_workbook("./bludhouse.xlsx")
read_ws = read_wb.active

list = []

for i in range(1,151) :
    print(read_ws.cell(i,1).value.strip())
    list.append(str(read_ws.cell(i,1).value.strip()))

print(list)