python怎么用pandas或者openpyxl将excel中一个区域的值复制到另一个工作簿中的区域

Question

python中如将一个excel工作簿中A1:G15区域的数据复制到另一个工作簿B2：H16中(尽量用pandas或open pyxl，我才学）

Answer 1

openpyxl，按行获取数据后存储在列表中，然后再重新写入新的工作簿中。

from openpyxl import load_workbook
from openpyxl import Workbook

workbook = load_workbook('demo.xlsx')
workbook1 = Workbook()

sheet = workbook.active
sheet1 = workbook1.active
ls1 = []
cells = sheet['A1:G15']
for row in sheet.rows:
    for i in row:
        ls1.append(i.value)

cells2 = sheet1['B2:H6']
n=0
for row2 in sheet1.iter_rows(min_row=2,min_col=2):
    for i in row2:
        i.value = ls1[n]
        n+=1
workbook1.save(filename = 'ouput.xlsx')