Python-Excel-09-复制单元格区域

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 = True  # 是否显示Excel文件
wb = xl_app.Workbooks.Open(excel_address)
sht_old = wb.Worksheets("原")
sht_new_1 = wb.Worksheets("复制1")
sht_new_2 = wb.Worksheets("复制2")
sht_new_3 = wb.Worksheets("复制3")

# 复制工作表
rng_data = sht_old.Range(sht_old.Cells(1, 1), sht_old.Cells(5, "C"))
rng_data.Copy()
sht_new_1.Paste(Destination=sht_new_1.Range("A1"))
sht_new_2.Range("A1").PasteSpecial(Paste=c.xlPasteValues)
sht_new_3.Range("A1").PasteSpecial(Paste=c.xlPasteAll)

wb.Save()
wb.Close()
xl_app.Quit()