新人求指教，请帮忙！

Question

我想问，我想从一个表全选拷贝东西，然后到指定excel表的sheet里完全覆盖，该如何写代码。

新人学习不容易，请指点。

Answer 1

参考地址：https://blog.csdn.net/u014597198/article/details/83104653

1. 选择一个读写excel表格的包
2. 尝试逐单元格读取excel的内容
3. 尝试逐单元格写入之前读取的excel表格内容

 

Answer 2

import xlwings as xw
import time
from time import sleep
app = xw.App ( visible=True, add_book=False )
wb = app.books.open (r'E:/䐁蕳/营销渠道保单清单.xlsx')
sht = wb.sheets['sheet1']
time.sleep(5)
wb1= app.books.open ( r"C:/Users/Administrator/Desktop/KPI2.xlsm" )
time.sleep(5)
wb.sheets["sheet1"].api.Copy(Before=wb1.sheets["更新业绩表"].api)
time.sleep(1)
#关闭sheet1
sht2 = wb1.sheets['sheet1']
sht1 = wb1.sheets['更新业绩表']
sht1.range("a1").expand("table").clear_contents()
sht2.range("a1").expand("table").api.Copy(sht1.range('a1').api)
time.sleep(0.5)
sht2.delete()