I met with a problem when I submit a job that deals with an excel file to CCS. The problem is as follows:
First, I have a platform of windows cluster with several nodes, and the OS of the platform is Windows server 2008 HPC edition. And I wrote a script to process an excel file, the key codes are as follows:
xlApp = win32com.client.Dispatch('Excel.Application')
xlBook = xlApp.Workbooks.Open(os.path.join(os.getcwd(),filename))
The codes ran on one node of the cluster successfully ,but when I submit the job to the CCS(Cluster computing server) ,It failed when open the Excel file. The error is as follows:
Exit code :1
Traceback (most recent call last):
File "excelProcess.py", line 128, in <module>
case1 = ExcelProcess("
\\\\ITIS-HEAD\\Users\\Administrator\\Desktop\\1\\test_hicks\\test.xls")
File "excelProcess.py", line 21, in __init__
self.xlBook = self.xlApp.Workbooks.open(filename)
File "<COMObject <unknown>>", line 2, in open
pywintypes.com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, u'Microsoft Office Excel', u'\u7c7b Workbooks \u7684 Open \u65b9\u6cd5\u65e0\u6548', u'C:\\Program Files (x86)\\Microsoft Office\\OFFICE11\\2052\\xlmain11.chm', 0, -2146827284), None)
I had Office 2003 installed in all the nodes. And I used python2.6 to write the script. I hope that I had describe the problem clearly ,Thank you for your help.