python学习系列2

import xlwings as xw
import pandas as pd
app=xw.App(visible = False, add_book = False)
f='E:\\XX\\XX\\XX-周报清单\\附件2-1：XX-XX清理信息（XX部核查结果20221111）.xlsx'
df1=pd.read_excel(f,sheet_name='1.待XX清单汇总（待XX订单总清单）',skiprows=2,dtype='object',usecols='A:Z')
df2=pd.read_excel(f,sheet_name='2.XX已操作终止订单明细',skiprows=1,dtype='object',usecols='A:Z')
df1=df1.dropna(how='all')
df2=df2.dropna(how='all')
df1=df1.dropna(subset=['凭证签订的终止日期'])
df2=df2.dropna(subset=['凭证签订的终止日期'])
df3=pd.concat([df1,df2],axis=0)#纵向合并两个文件
df3.to_excel('E:\\学会Python\\测试文件夹\\测试保存04.xlsx',index=False)
app.quit() #退出Excel程序
print(df3)