Excel: IF Null THEN take value from assgined parameter

Best practices, code snippets for common functionality, examples, and guidelines.
dugovic.milan
Posts: 41
Joined: Wed Jun 29, 2016 1:19 pm
Location: Frankfurt, Germany
Contact:

Excel: IF Null THEN take value from assgined parameter

Post by dugovic.milan » Tue Nov 22, 2016 11:30 am

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?
Ranorex 8.3.0

User avatar
RobinHood42
Posts: 238
Joined: Fri Jan 09, 2015 3:24 pm

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

Post by RobinHood42 » Thu Nov 24, 2016 12:41 pm

Hi,

I'm afraid that this is not possible. The integrated Excel data connector skips rows which do not have a value:
ExcelDataConnector.png
ExcelDataConnector.png (12.99 KiB) Viewed 641 times
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