在尝试通过Python运行Excel宏时遇到错误：`pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2146788248), None)`和`运行时错误 1004`。问题在于宏可能未在工作簿中定义或者宏安全设置禁用了所有宏。解决方案是确保启用所有宏，并正确指定工作簿路径和宏名。提供了一段成功运行Excel宏的Python代码示例。"
122641730,5884820,Python CSV与Pandas处理CSV文件详解,"['python', 'pandas', '数据处理', 'csv']
I need to run an Excel macro via python and I always get the following error :
result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args)
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2146788248), None)
In Excel, it is giving the following error :
Run-time error 1004:
Cannot run the macro ". The macro may not be available in this workbook or all macros may be disabled.
My code is the following :
xl=win32.Dispatch("Excel.Application")
wb=xl.Workbooks.Open(Filename="Path+MyExcelFile.xlsm", ReadOnly=1)
xl.Visible = True
time.sleep(1)
ws=wb.Worksheets("Sheet1")
ws.Cells(4,2).Value='Value1'
ws.Cells(5,2).Value='Value2'
ws.Cells(
最低0.47元/天 解锁文章
1024
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
