How to get the corresponding columns values in studiox

Help StudioX
,
1

Hi Team,

I have excel sheet which is having two columns.
Name Number
A 1
B 2

i need to select the option in a website, if Name is A I have to type 1 in number column
There can be increase of rows. Can anyone help me to achieve this Studiox.

thanks in advance

2

Hi @Nagini_Pragna

You can use the excel activities to do this.
=> Use get text activity to scrap the data in website and store in a variable. Let’s called variable name as WebData.
=> Use excel file activity and provide the excel file path.
=> Inside Use excel file activity insert an assign activity and create a count variable with int datatype.

- Assign -> Count = 1

=> Inside use excel file activity insert the for each excel row activity to iterate the each excel row.
=> If currentrow(“Name”).equals(WebData)
=> Inside then block use write cell activity to write the count in the Number row
=> In the range block give like this - Currentrow.byField(“Number”)

Hope it helps!!

3

Thanks for the reply. I am confused about few things.

I dont see assign activity in Studiox.

I have to write inside website(I can say like select the option based on the excel column B)

For suppose My name is A, In website I need to select the option 1.
SO I need help how to get the data from excel so that accordingly I can select the option in website.

I am sorry, if I missed anything. Please help i am new to studiox.

thanks.

4

In Studio X there is Set Variable activity instead of Assign activity. @Nagini_Pragna

Okay you have already excel values in numbers column also.
If yes, then follow the below one

=> Use get text activity to scrap the data in website and store in a variable. Let’s called variable name as WebData.
=> Use excel file activity and provide the excel file path
=> Inside use excel file activity insert the for each excel row activity to iterate the each excel row.
=> If currentrow(“Name”).equals(WebData)
=> Inside then block take an Set Variable activity to store the Numbers column value. Create a variable Let’s call it as output.
→ Output = Currentrow(“Numbers”).
=> Use type into activity to write the Output variable data in to the website.

Hope you understand!!