mint
(Mintoo)
August 1, 2024, 3:36am
1
hi
i have url that will have a combination of variable how can i put that in excel so the variable value get into that open browser activity
ex. “www.google.com/page ”+Var.trim.tostring
var is variable that will contain a number
if i pass this in excel so it passing that directly in open browser activity
Parvathy
(PS Parvathy)
August 1, 2024, 3:42am
2
Hi @mint
Where are you getting the numbers that you are storing in a variable.
Regards
mint
(Mintoo)
August 1, 2024, 3:47am
3
@Parvathy its a logic created from there it gets in
Hi @mint ,
Why do we need to store it in excel and read.?
If it is fine you can directly pass the URL to open browser na.?
Can you add what exactly are we trying to achieve here
Parvathy
(PS Parvathy)
August 1, 2024, 3:53am
5
Hi @mint
Can you please specify what are you exactly trying to achieve with help of some screenshots.
Regards
mint
(Mintoo)
August 1, 2024, 3:53am
6
actually i am trying to make this dynamic i have 6 different URL as script is common so to make sure we can switch directly from excel i am trying to achieve that way so before execution URL can be selected as per change
@Parvathy @Gautham_Pattabiraman
mint
(Mintoo)
August 1, 2024, 4:06am
7
@Parvathy i am just trying make sure that whatever URL is there in excel that should open but yes that might have a variable in it
Parvathy
(PS Parvathy)
August 1, 2024, 4:30am
8
Hi @mint
Can you tell where you are getting the numbers from into that variable.
Regards
mint
(Mintoo)
August 1, 2024, 4:45am
9
yes basically if var is there that means its a number however its string type var
Hey @mint
just a suggestion, instead of making use of an excel, To make it dynamic why can’t you make use of Switch statetment.?
Thanks,
gautham
1 Like
mint
(Mintoo)
August 1, 2024, 10:38am
11
yes i am using switch statement option only was looking if that is possible to do
Cool.! Hope you got it working.
Please mark the post that helped you as solution.
Else if you still want to know how to use via excel,
Use a config.xlsx file, Store the URL’s static parts. Read and initiate inside the solution. Dynamic number part to form a full URL and pass it on to open browser.
Thanks,
gautham.
system
(system)
Closed
August 4, 2024, 2:39pm
13
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.