# -*- coding: utf-8 -*- import sys sys.stdout.reconfigure(encoding='utf-8') import openpyxl from openpyxl.utils import get_column_letter wb = openpyxl.load_workbook('작업현황.xlsx'); ws = wb.active print('sheet:', ws.title, 'dims', ws.max_row, ws.max_column) for r in range(1, min(ws.max_row, 50) + 1): vals = [ws.cell(r, c).value for c in range(1, ws.max_column + 1)] if any(v not in (None, '') for v in vals): print(r, vals)