A表
B表
实现效果
# -*- coding: utf-8 -*-
"""
Created on Sun Dec 1 11:41:23 2019
"""
date_input = '2019-11-29'
#1、应用xlwings包
import xlwings as xw
#2、读取待复制的表格
path = 'C:UsersxlwingsDesktopexcelpythondemo2.xlsx'
workbook = xw.Book(path)
#3、读取待粘贴的表格
path2 = 'C:UsersxlwingsDesktopexcelpythondemo1.xlsx'
workbook2 = xw.Book(path2)
#3-1、找到最后一行的第一个单元格
rng2 = workbook2.sheets("Sheet1").range('A1').expand('table')
cell_index = str(rng2.rows.count+1)
range1 = workbook2.sheets("Sheet1").range('A'+cell_index)
#3-2、过滤数据
rng = workbook.sheets("Sheet1").range('A1').expand('table')
#3-2-1、将满足条件的行放到列表
full_record = []
for r in rng.value[1:]: #[1:] 表示不读取标题行
if r[0].strftime('%Y-%m-%d') == date_input:
full_record.append(r)
#3-3、将列表数据赋值到选定的单元格
range1.value = full_record