IF Else not working



I’m having trouble with the IF/Else statement. I pull cell data from excel in number format, set it to a variable (which is number) but it doesn’t work.

RPA ClassCast error for Calculated Expression type variable

I think your clipboard action should be set variable value from clipboard, i.e., to ‘totalprice’.


No, still not working. I set up a simple test with an excel sheet. The cells are formatted as numbers, and RPAx stops when it reaches step 10:



And variable:

Any tips? Kinda stuck without IF/else not working.


change cellvalue type from number to string? not sure whether it works.


No, did that as well, received an error:

So, until this works, RPAx needs to rely on excel mending the gaps.


@CWaago-Hansen_PwC1 - when you copy some value from excel bu CTRL + C - you copy the value itself + CR LF (new line symbol).

In the upcoming release, we will introduce the Trim function which solves this problem .

Meanwhile, you can use this workaround - https://superuser.com/questions/543615/copy-from-excel-without-line-break

You can also use the Excel action in RPA Recorder - https://kb.workfusion.com/display/RPAe/Excel


Thanks azinchuk, the workaround did it. The Excel action wouldn’t work here as I had opened the workbook, or am I wrong here?
Anyway, the workaround worked for both number and string variable.


This one is pretty common. Can we please post it to our KB?


Described here https://kb.workfusion.com/display/RPAe/Clipboard