# -*- coding: utf-8 -*- import openpyxl wb = openpyxl.load_workbook(r'D:/01.프로젝트/DB수집/작업파일/공공기관3/공공기관3_작업현황.xlsx', data_only=True) ws = wb.active print('SHEET', ws.title, 'rows', ws.max_row) for r in ws.iter_rows(min_row=1, max_row=18, values_only=True): print(list(r))