Page 1 of 1

Excel: IF Null THEN take value from assgined parameter

Posted: Tue Nov 22, 2016 11:30 am
by 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?

Re: Excel: IF Null THEN take value from assgined parameter

Posted: Thu Nov 24, 2016 12:41 pm
by 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. :mrgreen:

Cheers, Robin