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

[Ziliang Guo <ziliang@xxxxxxxxxxx>]

Running Excel under HTCondor is a tad complicated. We have a howto
page here: https://htcondor-wiki.cs.wisc.edu/index.cgi/wiki?p=ExcelJobs
that discusses some of the issues. Though I would need more details on
what your program is to try to replicate the conditions. It sounds
like you're using the .NET Office Interop tools. Is that the case?

On Fri, Dec 6, 2013 at 3:06 AM, Dennis Zheleznyak <dennis@xxxxxxxxxxxxx> wrote:
> Is there something I can do to as a workaround maybe?
>
>
> On Thu, Dec 5, 2013 at 5:09 PM, Stub <spamrefuse@xxxxxxxxx> wrote:
>>
>> The Condor context does not seem to have a GUI, whereas the CMD
>> environment kind of still has......it could be that the Excel support in
>> Matlab chokes on that.....just a wild guess. -Rob.
>>
>>
>> On Thursday, December 5, 2013 8:19 PM, Dennis Zheleznyak
>> <dennis@xxxxxxxxxxxxx> wrote:
>> 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.
>>
>> _______________________________________________
>> HTCondor-users mailing list
>> To unsubscribe, send a message to htcondor-users-request@xxxxxxxxxxx with
>> a
>> subject: Unsubscribe
>> You can also unsubscribe by visiting
>> https://lists.cs.wisc.edu/mailman/listinfo/htcondor-users
>>
>> The archives can be found at:
>> https://lists.cs.wisc.edu/archive/htcondor-users/
>>
>>
>> _______________________________________________
>> HTCondor-users mailing list
>> To unsubscribe, send a message to htcondor-users-request@xxxxxxxxxxx with
>> a
>> subject: Unsubscribe
>> You can also unsubscribe by visiting
>> https://lists.cs.wisc.edu/mailman/listinfo/htcondor-users
>>
>> The archives can be found at:
>> https://lists.cs.wisc.edu/archive/htcondor-users/
>
>
>
> _______________________________________________
> HTCondor-users mailing list
> To unsubscribe, send a message to htcondor-users-request@xxxxxxxxxxx with a
> subject: Unsubscribe
> You can also unsubscribe by visiting
> https://lists.cs.wisc.edu/mailman/listinfo/htcondor-users
>
> The archives can be found at:
> https://lists.cs.wisc.edu/archive/htcondor-users/



-- 
HTCondor Project Windows Developer / NEOS Maintainer