问题遇到的现象和发生背景

问题相关代码，请勿粘贴截图

doc_open = docApp.Documents.Open(os.path.abspath(filepath))
time.sleep(2)
worksheet = doc_open.InlineShapes(1).Chart.ChartData.Workbook.Worksheets("Sheet1")#打开图表关联的excel表格
time.sleep(2)

# 清空工作表默认数据

worksheet.Range("A1:D20").value = None

填入测试数据

for row_index,row in enumerate(finaldata):
for column_index,value in enumerate(row):
worksheet.Cells(row_index+1,column_index+1).Value = value

doc_open.Save()
doc_open.Close()

docApp.Quit()

doc=Document(filepath)

运行结果及报错内容

com_error Traceback (most recent call last)
in
150 doc_open = docApp.Documents.Open(os.path.abspath(filepath))
151 time.sleep(2)
--> 152 worksheet = doc_open.InlineShapes(1).Chart.ChartData.Workbook.Worksheets("Sheet1")#打开图表关联的excel表格
153 time.sleep(2)
154 # # 清空工作表默认数据

c:\users\administrator\appdata\local\programs\python\python36\lib\site-packages\win32com\client\dynamic.py in getattr(self, attr)
541 debug_attr_print("Getting property Id 0x%x from OLE object" % retEntry.dispid)
542 try:
--> 543 ret = self.oleobj.Invoke(retEntry.dispid,0,invoke_type,1)
544 except pythoncom.com_error as details:
545 if details.hresult in ERRORS_BAD_CONTEXT:

com_error: (-2147352567, '发生意外。', (0, None, None, None, 0, -2147467259), None)

我的解答思路和尝试过的方法

我想要达到的结果