补充一下错误反馈:
Traceback (most recent call last):
File "<input>", line 1, in <module>
File "C:\Program Files\JetBrains\PyCharm 2020.1.1\plugins\python\helpers\pydev\_pydev_bundle\
pydev_umd.py", line 197, in runfile
pydev_imports.execfile(filename, global_vars, local_vars) # execute the script
File "C:\Program Files\JetBrains\PyCharm 2020.1.1\plugins\python\helpers\pydev\_pydev_imps\
_pydev_execfile.py", line 18, in execfile
exec(compile(contents+"\n", file, 'exec'), glob, loc)
File "C:/Users/hyani/Documents/Masterpiece/demo/
zh.py", line 21, in <module>
sht.range(A[i]).formula = '='+C[i]+'/1.01'
File "C:\Users\hyani\AppData\Local\Programs\Python\Python38\venv\lib\site-packages\xlwings\
main.py", line 842, in range
return Range(impl=self.impl.range(cell1, cell2))
File "C:\Users\hyani\AppData\Local\Programs\Python\Python38\venv\lib\site-packages\xlwings\
_xlwindows.py", line 610, in range
xl1 = self.xl.Range(arg1)
File "C:\Users\hyani\AppData\Local\Programs\Python\Python38\venv\lib\site-packages\xlwings\
_xlwindows.py", line 66, in __call__
v = self.__method(*args, **kwargs)
File "<COMObject <unknown>>", line 2, in Range
pywintypes.com_error: (-2147023170, '远程过程调用失败。', None, None)