主页 / 问题 / 1091743
Accepted
Евгений
Asked:2020-03-07 15:20:10 +0000 UTC2020-03-07 15:20:10 +0000 UTC

从另一个工作表复制 excel 行

  • 772

告诉我，是否可以使用 Python 和 openpyxl 库将整行（行）从一张纸复制到另一张纸上？

例如像这样：

for row in sheet:
     sheet2.append(row)

现在这段代码对我不起作用。

python

2 个回答

  1. Best Answer

    此示例将工作表的第二行添加到工作表Sheet2的末尾，并Sheet1 保留格式：

    from copy import copy
from openpyxl import load_workbook

def copy_cell(src_sheet, src_row, src_col, 
              tgt_sheet, tgt_row, tgt_col,
              copy_style=True):
    cell = src_sheet.cell(src_row, src_col)
    new_cell = tgt_sheet.cell(tgt_row, tgt_col, cell.value)
    if cell.has_style and copy_style:
        new_cell._style = copy(cell._style)

filename = r"c:\temp\test.xlsx"
wb = load_workbook(filename)
ws1 = wb['Sheet1']
ws2 = wb['Sheet2']


ws1_last_row = ws1.max_row

for i,row in enumerate(ws2.iter_rows(min_row=2, max_row=2), 1):
    for cell in row:
        copy_cell(ws2, cell.row, cell.column, 
                  ws1, ws1_last_row+i, cell.column)

wb.save(filename)
    • 3

  2. 工作示例（用 测试openpyxl 3.0.3）：

    from openpyxl import load_workbook

filename = r"c:\temp\test.xlsx"
wb = load_workbook(filename)
ws1 = wb['Sheet1']
ws2 = wb['Sheet2']

# добавляем вторую строку из [Sheet2] в конец [Sheet1]
_ = [ws1.append(row) for row in ws2.iter_rows(min_row=2, max_row=2, values_only=True)]

wb.save(filename)
    • 1

相关问题