Excel: IF Null THEN take value from assgined parameter

[dugovic.milan]

Hello everyone. I've been thinking about following solution for my project, which uses Excel files as a datasource. I'd like to specify following:

- Ranorex, when you don't find any value or your reference in Excel-file's variable is NULL, THEN take the value from assgined parameter

in other words

- Ranorex, when you find a value in your Excel-file's variable, THEN don't bother yourself about any parameter

Any ideas how to solve this problem?

[RobinHood42]

Hi,

I'm afraid that this is not possible. The integrated Excel data connector skips rows which do not have a value:

ExcelDataConnector.png

Also, your requirements would need a custom implementation at some point. So, you could probably implement your own datasource mechanism, but this won't be that easy for sure.

Cheers, Robin