分享复制 sheet 页的一个函数 (包含格式)

import xlwings as xw

def copy_sheet(file, sheet, to_sheet=None):
'''
:param file: 文件路径
:param sheet: 复制的 sheet
:param to_sheet: 要复制到的 sheet 名
:return:
'''
wb1 = xw.Book(file) # 打开原始表格
if not to_sheet:
to_sheet = sheet + ‘(2)’
wb1sht = wb1.sheets[sheet]
sheet_arr = [i.name for i in wb1.sheets]
print(sheet_arr)
wb1sht.api.Copy(Before=wb1sht.api)
sheet_arr = [i.name if i.name not in sheet_arr else '' for i in wb1.sheets]
shtCpoy = wb1.sheets[''.join(sheet_arr)]
shtCpoy.name = to_sheet
wb1.save(file)
wb1.close()