ExcelWriter.xlsm文件损坏

Question

使用python中的pandas，我想用下面的代码在现有的.xlsm文件上添加工作表

然而，在运行进程之后，我得到“我们发现sample.xlsm中的某些内容存在问题。你想让我们尽力恢复吗？如果您信任此工作簿的来源，请单击“是”。警告

我如何解决这个问题？谢谢

import pandas as pd
import numpy as np
from openpyxl import load_workbook
import copy
import time

dfTRYprod = pd.readexcel('sample2.xlsm', sheetname='TRY Products', usecols ="A:AZ", nrows=100, indexcol = 0)
book = loadworkbook(sample.xlsm, readonly=False, keep_vba=True)

options = {}
options['stringstoformulas'] = False
options['stringstourls'] = False

writer=pd.ExcelWriter (paths, engine= 'openpyxl',options=options)
writer.book = book

del book['TRY Products']

dfTRYprod.toexcel(writer, sheet_name='TRY Products')

writer.save()
writer.close()