[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[HTCondor-users] Excel issue when using Matlab with Condor.

Hello all,

We are using the following layout:
Latest 8.1.2 Condor
Windows 7 Professional 64Bit
Microsoft Office 2007 Enterprise
MatLab R2013a

We've complied a small program that accepts a parameter, searches for it inside the first column of an Excel sheet and prints the content of the line to a file which the compiled program creates. 

When running the program through CMD it works properly, as intended (a file is being created with the content of the desired line):
program.exe <string parameter>

When sending it through Condor, the following error is received:

{ Error using Interface.000208DB_0000_0000_C000_000000000046/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Office Excel
Description: Microsoft Office Excel cannot access the file
'C:\condor\execute\dir_10592\DataBase22.xlsx'. There are several possible

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open
Help File: C:\Program Files (x86)\Microsoft Office\Office12\1033\XLMAIN11.CHM
Help Context ID: 0

Error in xlsreadCOM (line 13)
Error in xlsread (line 230)
Error in demo22 (line 31)

This is our condor submit file:

executable = readingexcel.exe
arguments = 657
input = DataBase22.xlsx
transfer_input_files = DataBase22.xlsx
universe = vanilla
output = output.$(cluster)
error = error.$(cluster)
log = log.$(cluster)
should_transfer_files = YES
when_to_transfer_output = ON_EXIT
getenv= True
load_profile = True
queue 1

The excel sheet opens properly, it is copied to the temporary condor\execute folder and has valid data inside.

I searched for a solution in Google, tried adding 'basic' to the xlsread and it didn't help either.

I also made sure that all excel processes are closed before starting the job. 

Does anyone have any suggestion ?

Thank you,