问题遇到的现象和发生背景
我想利用Jenkins的持续集成功能让python一分钟执行一次,在pycharm写好代码后也运行过是可以添加数据到excel表里的,但是在Jenkins里缺一直报错。
问题相关代码,请勿粘贴截图
import sys
sys.path.append(r'D:\liangyx\pyproject')
import xlwings as xw
from datetime import datetime
from page.DDM_script import OTU2_DDM_script
x=OTU2_DDM_script()
C1=x[0:9]
C2=x[9:18]
C3=x[18:27]
C4=x[27:36]
L1=x[36:50]
L2=x[50:64]
data=('Port','Port Name','Lane','TX Power(dBm)','RX Power(dBm)','Bias(mA)','Volt(V)','Temperature(℃)','SN','DSP Temperature(℃)','Correct Symbol Error Rate','Incorrect Symbol Error Blocks','TX Power Setting Value(dBm)','CFP2 WorkMode')
t=str(datetime.now())[0:13]+"'"+str(datetime.now())[14:16]+'"'+str(datetime.now())[17:19]
wb=xw.App(visible=False,add_book=False)
work_book=wb.books.open('test2.xlsx')
sheet=work_book.sheets.add(t)
sheet.range('A1:N7').api.Font.Name='微软雅黑'
sheet.range('A1:N7').api.HorizontalAlignment = -4108
sheet.range(1,1).value=data
sheet.range(2,1).value=C1
sheet.range(3,1).value=L1
sheet.range(4,1).value=C2
sheet.range(5,1).value=C3
sheet.range(6,1).value=L2
sheet.range(7,1).value=C4
sheet.range('A1').column_width=6
sheet.range('B1').column_width=10
sheet.range('C1').column_width=8.38
sheet.range('D1').column_width=13.62
sheet.range('E1').column_width=13.62
sheet.range('F1').column_width=8.38
sheet.range('G1').column_width=8.38
sheet.range('H1').column_width=15.38
sheet.range('I1').column_width=16
sheet.range('J1').column_width=20
sheet.range('K1').column_width=26.5
sheet.range('K1').column_width=26.5
sheet.range('L1').column_width=30
sheet.range('M1').column_width=28
sheet.range('N1').column_width=19
work_book.save('test2.xlsx')
work_book.close()
wb.quit()
运行结果及报错内容
我的解答思路和尝试过的方法
有试过这个方法,但还是不行
https://blog.csdn.net/m0_56083621/article/details/115041998?spm=1001.2014.3001.5502
我想要达到的结果
可以在Jenkins运行成功,并且一分钟运行一次