3. Script Language > Browser and Office (Acc.-Engine) > OFC. - Office-Commands > MS-Excel Scripting

OFC. - Office-Commands/MS-Excel Scripting

MiniRobotLanguage (MRL)

OFC.Excel|EXIST

Verify if MS-Excel is installed and functional

Intention

Normally all SPR commands for use with "MS Excel" need an valid Installation of MS-Office Excel.

There is one exception that is the "EXIST" Command. This command will always execute and return whether a "1" or a "0" on the TOS.

Excel is installed -> 1

Excel is not installed -> 0

This command will internally check the Registry if the Entry for Excel is set properly.

Secondly this command will check if the SPR can access the Excel internal Interfaces.

Only if all of this works, then the command will return "1" on TOS.

Else the command wil lreturn a "0" on TOS.

Syntax:

OFC.Excel|EXIST

Parameter Explanation:

Example:

' Check if MS-Excel is installed and functional

OFC.excel|Exist

DBP.$$000

ENR.

Remarks:

This command is automatically executed one time when the SPR starts and the first OFC.EXCEL command is executed.

For this reason, the first call to a Excel command may take a second longer then succeeding commands.

The result is internally remembered for Speed reasons.

So all further calls to OFC.EXCEL may fail if Excel was not working on first attempt.

Unless you call this command, which will do the check again and then set the internal values new.

Limitations: