import os
import xlwings as xw
files_path = r'C:/Users/Peter Pro/Desktop/zh'
app = xw.App(visible=True, add_book=False)
app.display_alerts = False
app.screen_updating = False
A=['D14','E14','F14','G14','H14','I14','J14','K14','L14','M14']
B=['D15','E15','F15','G15','H15','I15','J15','K15','L15','M15']
C=['D13','E13','F13','G13','H13','I13','J13','K13','L13','M13']
D=['C15','D15','E15','F15','G15','H15','I15','J15','K15','L15']
for files_path_0, dirs, files in os.walk(files_path):
for file in files:
wb = app.books.open(files_path+'/'+file)
sht = wb.sheets['测算表']
for i in range(9):
sht.range(A[i]).formula = '='+C[i]+'/1.01'
sht.range(B[i]).formula = '=IF('+A[i]+'<=100000,'+A[i]+'*1.01,IF('+A[i]+'>100000,'+A[i]+'))+'+D[i]
wb.save()
wb.close()
app.quit()
app.kill()
# 如上代码发现发生意外,已经试过很多方法,比如修改注册路径、重装等,仍然无法解决。新手,求大神指点,**不知道是代码写的问题,还是系统接口调用问题,怀疑自己,跪谢大神。**