python完整复制excel模板_请问大神，用Python的什么语句可以实现复制excel的完整格式和图片？...

def xw_split_books(filepath):

dirpath = os.path.join(self.dirpath, self.basename)

create_dirpath(dirpath)

wb = xw.Book(filepath)

for sht in wb.sheets:

filename = os.path.join(dirpath, "%s.xlsx" % sht.name)

sht.activate()

sht.api.Copy()

new = xw.books.active

new.screen_updating = False

new.display_alerts = False

print(new,filename)

new.save(r"%s" % filename)

new.close()

self.progress_signal.emit("【人文君】工作表：%s已保存为新的excel文件！" % sht.name)

self.progress_signal.emit("【人文君】完成啦！共拆分%s个工作表！请到%s目录下查看" % (len(wb.sheets), dirpath))