Python-Excel-08-复制工作表

import os
import win32com
from win32com.client import constants as c  # 旨在直接使用VBA常数
current_address = os.path.abspath('.')

excel_address = os.path.join(current_address, "复制工作表.xlsx")
xl_app = win32com.client.gencache.EnsureDispatch("Excel.Application")  # 若想引用常数的话使用此法调用Excel
xl_app.Visible = False  # 是否显示Excel文件
wb = xl_app.Workbooks.Open(excel_address)
sht = wb.Worksheets("示例")

# 复制工作表
new_sht_name = "新复制"
sht.Copy(After=sht)
wb.ActiveSheet.Name = new_sht_name
sht_copy = wb.Worksheets(new_sht_name)
sht_copy.Range("B1").Value = "复制"

wb.Save()
wb.Close()