python中如将一个excel工作簿中A1:G15区域的数据复制到另一个工作簿B2:H16中(尽量用pandas或open pyxl,我才学)
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')