Set Evaluation Mode

This action changes the evaluation option for an Excel value of an Excel variable. It is only used for Excel variable data.

Limitations and recommendations:

• It is not possible to enter formulas containing unsupported features, because this generates an error while parsing the formulas.

• If an Excel document contains unsupported features, it is possible to load the document into a robot and read data from it.

• If you enter new data into the Excel document, expression in the document is re-evaluated, generating an error when running the robot.

  To prevent this error, set the evaluation mode to false.

• When designing a Basic Engine robot with an Excel document that contains unsupported features, start with a Set Evaluation Mode step.

  • If you need to track how the document changes while you are creating the robot, open the Excel variable externally.

  • Use the Data State view to create a temporary file from the variable.

  • Open the document in Excel and press Ctrl+Alt+F9 to make Excel re-evaluate the document.

  • Every time you want to see a change, open the variable externally and repeat the steps to re-evaluate the document.