app xw.App(visible True, add_book False)
wb app.books.open( C:\Users\Administrator\Desktop\测试\测试.xlsx )
ws wb.sheets[0]
wc ws.range( A7 ).expand( table ).value
print(wc)
new_wb xw.Book( C:\Users\Administrator\Desktop\测试\统计表.xlsx )
new_sh new_wb.sheets[0]
scope new_sh.range( A1 ).expand()
new_sh.range(scope.shape[0] 1,1).value wc
print(scope)
new_wb.save()
new_wb.close()
wb.close()
app.quit()