Select ListItem from Excel data

[romainb25]

Hi community,

I have a ListItem with some items inside : ListItemBOOK,ListItemBOOK2,ListItemBOOK3,ListItemBOOK4(see picture below)

I have an excel file with a type column.
When i launch the test case, i want to get type in my excel column and select it in my ListItem, in my script i want something like this:

repo.FormOperation.Panel21. <<type?>> .Click("35;10");

Dessin sans titre.png (16.12 KiB) Viewed 802 times

How can i do this?

thanks
romainb25

[odklizec]

Hi,

Any chance to post the excel file in question? It would be much easier to suggest a solution with actually working sample file, instead of screenshot.

[romainb25]

I can't upload a file with xls extension in this post.

My Excel column are bound to local variables

pb5.png (19.16 KiB) Viewed 792 times

In my script i can add variable in an edit text like this:
repo.Form.Text001.PressKeys(quantite);

But i can't select any element in my list :
repo.Form.ListView01. type? .Click("53;10");

Any idea?

thanks

[Support Team]

Hello romainb25,

Thank you for the additional information.

The problem is that you would need a Ranorex adapter element in order to use e.g., the Click()-method, but you just receive a "string"-value from your Excel sheet.

Sample:

UserCodeVariable.png (4 KiB) Viewed 768 times

"varButtonName" is the recording variable which is bound to the Excel sheet.

Hope this information helps.

Sincerely,
Robert