本文整理汇总了Python中win32com.client.Dispatch.clone方法的典型用法代码示例。如果您正苦于以下问题:Python Dispatch.clone方法的具体用法?Python Dispatch.clone怎么用?Python Dispatch.clone使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类win32com.client.Dispatch
的用法示例。
在下文中一共展示了Dispatch.clone方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: print
# 需要导入模块: from win32com.client import Dispatch [as 别名]
# 或者: from win32com.client.Dispatch import clone [as 别名]
if worksheet.name == sheet.name:
print("Skipping:",worksheet.name)
this_sheet = worksheet
print(this_sheet)
if 0:
with util_xl.ExtendedExcelBookAPI(full_path) as xl:
print(xl.book)
xl.DisplayAlerts = False
for sheet in xl.book.Worksheets:
print("Processing", sheet.name)
new_full_path = os.path.join(path_dir,'{}_split.xls'.format(sheet.name))
#raise
#new_workbook = copy.copy(xl.book)
new_xl = xl.clone(new_full_path)
#new_workbook.DisplayAlerts = False
#raise
#raise
print("New excel API:",new_xl)
#for worksheet in xl.book.Worksheets:
print("New excel API, book:",new_xl.book)
for worksheet in new_xl.book.Worksheets:
if worksheet.name == sheet.name:
print("Skipping:",worksheet.name)
#this_sheet = worksheet
else:
#sleep(0.05)
print("Deleting:",worksheet.name)
worksheet.Delete()
#worksheet.delete()