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

[Dennis Zheleznyak <dennis@xxxxxxxxxxxxx>]

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

reasons:

• 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

workbook.

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)

}  

MATLAB:COM:E2148140012

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,

Dennis.