错误“工作簿”对象没有属性“添加vba项目”

Question

我已成功提取了vbaProject.bin，但仍有错误。我的目标是能够在信息传递到xlsm文件后使用VBA。这是xlswriter提供的解决方法

import pandas as pd


def export(self):
    sql = "SELECT WellID,AFEno,AFEsuppno,AccountCode,AFEAmount FROM WellAFEDetails WHERE WellID = ?"
    df = pd.read_sql_query(sql,self.con, params=([self.wellid_bx.get()]))
    writer = pd.ExcelWriter (r'C:\Users\bjenks\Desktop\Macro.xlsm')
    df.to_excel(writer, sheet_name='Raw')
    workbook  = writer.book
    workbook.filename = (r'C:\Users\bjenks\Desktop\Macro.xlsm')
    workbook.add_vba_project(r'C:\Users\bjenks\Desktop/vbaProject.bin')
    writer.save()