如果openpyxl中整行为空,则上移单元格

以下是查找和删除空行的通用方法。

empty_rows = []
for idx, row in enumerate(ws.iter_rows(max_col=50), start=1):

  empty = not any((cell.value for cell in row))

  if empty:
    empty_rows.append(idx)

for row_idx in reversed(empty_rows):
  ws.delete_rows(row_idx, 1)

感谢查理·克拉克的帮助,我想出了一个可行的解决方案,如果我能改进一下,请告诉我:

i = 1
emptyRows = []
for row in ws1.iter_rows(min_row = 1, max_col=50, max_row = ws1.max_row):
  flag = 0
  for cell in row:
    if cell.value is not None:
      flag = 1

  if flag == 0:
    emptyRows.append(i)

  i += 1

for x in emptyRows:
  ws1.delete_rows(x, 1)
  emptyRows[:] = [y - 1 for y in emptyRows]