from openpyxl import load_workbook
exl = load_workbook(filename= 'test_1.xlsx')
sheet = exl.active
dim = sheet.dimensions
print(dim)
cells = sheet[dim]
# print(cells)
--法1
for rows in sheet[dim]:
for cell in rows:
if cell.value is None:
print(cell.coordinate)
--法2
for row in sheet.iter_rows(min_row = 1, max_row=52000, min_col=1,max_col=2):
for cell in row:
if not cell.value:
print(cell.coordinate)