如何在跳过空单元格的同时将数据从一个工作表复制到另一个工作表- Python和Openpyxl

import openpyxl

source_workbook = openpyxl.load_workbook('source.xlsx')
target_workbook = openpyxl.load_workbook('target.xlsx')

source_sheet = source_workbook['Sheet1']
target_sheet = target_workbook['Sheet2']

for row in source_sheet.iter_rows():
    # 跳过空行
    if all(cell.value is None for cell in row):
        continue
    # 复制数据到目标工作表
    target_sheet.append([cell.value for cell in row])

target_workbook.save('target.xlsx')