做爬虫时候涉及到2个表格间相互操作

做爬虫时候涉及到2个表格间相互操作，insert操作,代码验证可以，代码如下：

from openpyxl import load_workbook
import warnings

warnings.simplefilter('ignore')
src_wb = load_workbook('src.xlsx')
dest_wb = load_workbook('dest.xlsx')
ws1 = dest_wb.active
src_media_sheet = src_wb['media']
max_row = src_media_sheet.max_row
list = []
for i in range(max_row - 1):
    tmp_list = []
    for each in src_media_sheet.iter_cols(min_row=2):
        tmp_list.append(each[i].value)
    list.append(tmp_list)

for i in range(0, len(list)):
    ws1.append(list[i])
dest_wb.save('dest.xlsx')