使用Python调用win32复制Excel工作表中sheet到其他工作簿

功能是实现了，但是不知道.copy后面的None干啥的，也不知道为啥能成功。
代码如下:

# -*- coding:utf-8 -*-
import openpyxl as vb
from win32com.client import Dispatch
path1 = r'E:\python学习\课件表格\成绩表.xlsx'
path2 =r'E:\\python学习\\课件表格\\工资表.xlsx'

xl = Dispatch("Excel.Application")
xl.Visible = False # You can remove this line if you don't want the Excel application to be visible

wb1 = xl.Workbooks.Open(path1)
wb2 = xl.Workbooks.Open(path2)

ws1 = wb1.Worksheets(1)
ws1.Name = 'Built with Python'
print(wb2.sheets.count)

ws1.Copy(None,wb2.Worksheets(wb2.sheets.count))
#
wb1.Close(SaveChanges=True)
wb2.Close(SaveChanges=True)

xl.Quit()
[img]https://img.nga.178.com/attachments/mon_202105/21/-7Q2o-d2peK1wT3cSo8-g5.jpg.medium.jpg[/img]
总感觉让鸟头转圈飞起来了[s:ac:喷][s:ac:喷]