python打开一个不存在的文件报错_Jenkins构建执行Python脚本报错文件不存在

Jenkins构建的时候，报错文件或路径不存在，具体错误如下：BuildinginworkspaceC:\ProgramFiles(x86)\Jenkins\workspace\test[test]$cmd/ccallC:\windows\TEMP\jenkins11757570712364...

Jenkins构建的时候，报错文件或路径不存在，具体错误如下：

Building in workspace C:\Program Files (x86)\Jenkins\workspace\test

[test] $ cmd /c call C:\windows\TEMP\jenkins117575707123645061.bat

C:\Program Files (x86)\Jenkins\workspace\test>C:\Python36\Python3.exe E:\PyCharmProject\ALM2\test1.py

Traceback (most recent call last):

File "C:\Python36\lib\site-packages\xlwings\_xlwindows.py", line 432, in __call__

return Book(xl=self.xl(name_or_index))

File "C:\Python36\lib\site-packages\xlwings\_xlwindows.py", line 152, in __call__

v = self._inner(*args, **kwargs)

File "C:\Python36\lib\site-packages\win32com\client\dynamic.py", line 197, in __call__

return self._get_good_object_(self._oleobj_.Invoke(*allArgs),self._olerepr_.defaultDispatchName,None)

pywintypes.com_error: (-2147352567, '发生意外。', (0, None, None, None, 0, -2147352565), None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "C:\Python36\lib\site-packages\xlwings\main.py", line 2776, in open

impl = self.impl(name)

File "C:\Python36\lib\site-packages\xlwings\_xlwindows.py", line 434, in __call__

raise KeyError(name_or_index)

KeyError: 'XR_Summary_Date.xlsx'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "E:\PyCharmProject\ALM2\test1.py", line 24, in

book = xlsApp.books.open(file)

File "C:\Python36\lib\site-packages\xlwings\main.py", line 2787, in open

impl = self.impl.open(fullname)

File "C:\Python36\lib\site-packages\xlwings\_xlwindows.py", line 443, in open

return Book(xl=self.xl.Open(fullname))

File "C:\Python36\lib\site-packages\xlwings\_xlwindows.py", line 63, in __call__

v = self.__method(*args, **kwargs)

File ">", line 8, in Open

pywintypes.com_error: (-2147352567, '发生意外。', (0, 'Microsoft Excel', 'Microsoft Excel 不能访问文件“E:\\build\\XR_Summary_Date.xlsx”。 可能的原因有以下几个:\n\n\u2022 文件名称或路径不存在。\n\u2022 文件正被其他程序使用。\n\u2022 您正要保存的工作簿与当前打开的工作簿同名。', 'xlmain11.chm', 0, -2146827284), None)

C:\Program Files (x86)\Jenkins\workspace\test>exit 1

Build step 'Execute Windows batch command' marked build as failure

Finished: FAILURE

我在E盘里放了Python的脚本，内容如下：

import time

import xlwings as xw

path = "E:/build"

file_name = 'XR_Summary_Date.xlsx'

xlsApp = xw.App(visible=False, add_book=False)

file = path+'/' + file_name

book = xlsApp.books.open(file)

#文件处理过程

filename = file_name.replace('Date',time.strftime("%Y%m%d-%H%M%S", time.localtime()))

new_file = path+'/' + filename

book.save(new_file)

xlsApp.quit()

构建的时候，执行脚本为：

C:\Python36\Python3.exe E:\PyCharmProject\ALM2\test1.py

我在CMD命令行里这样执行时是没有问题的，但放到Jenkins里构建就有这样的问题，请高手帮忙。

展开