・やりたいこと
Excelから値を取得して、値を変数に格納したのち変数を検索ワードとしてブラウザを立ち上げたいです。
・できていること
Excelから値を取得し変数に代入を行いました。それをURLの検索部分にパラメータとして設定しました。
・問題点
設定行うことはできていますが、実行すると動的遷移できていない。なお、プロパティのURLとセレクターは以下の通りに設定しています。
URL：string.Format(“Bluesky”+Paramee)
セレクター：
・理解てきていない点
正直セレクターの設定があんまり理解できていないように思います。どこがだめなのかがわかっていない。
まだそこまで詳しくないので、お手数ですが回答する際かみ砕いていただけると助かります。
Hie @seki_i so it seems like you have to take value from excel and store them in a variable and then pass this variable into the following open browser .
kindly follow these steps
1- Excel process scope → use excel file->read range-> save output as[for eq-] (dt)
now use for each row-> pass the variable of read range
now inside the for each use → use application/browser and inside the activity pass the value as follow → currentrow("yourvalue).tostring
ps- kindly note these all are modern activity
and if you are working with classic activity
there are slight changes like you have to use excel application scope use read range
and for browser use open browser activity
cheers
Thank you for your reply. I followed the advice and configured the settings as instructed, but it didn’t work. I am using the criterion of whether part of the information on the destination page could be extracted as a table for judgment.
Additionally, I would like to confirm something: I inserted currentrow("Paramee").tostring directly into the browser URL, but after executing it, when I checked the console, “Paramee” was recognized as a literal string and not as a variable. How can I make it recognized as a variable within the URL?
Hie @seki_i replace build data table with your excel file
as you can check (the BROWSER i mentioned is column name which i passed in the current row and and also i can see you only put single quotation so do i as shown in the image.
and can you show me your excel file where you get the data.
Thank you.
Here is the content of the Excel file I am using.
Book1.xlsx (23.0 KB)
Have the Query is resolved now ? and if not which excel sheet you are using ?
Apologies.
The query has not been resolved yet. I am using Sheet2 and Sheet3 in the Excel file. The data source is from columns B to D in Sheet2.
@seki_i as i see in your excel the cells are blanks and there are not plan values these are some formula and also there are not header in the columns. so i’m not so sure what values are inside those cells so first simply use get cell activity and then check the output what type of value you are getting is it the URL you are getting or somthing else .if you get the URL before the use browser (use read cell)activity store the data and then pass the output data of read cell into the URL container of Use application/browser Activity.
Thank you very much!
The data to be retrieved from the cell is not a URL, but rather a “word”. In that case, is it still okay to pass it to the URL container of the “Use Application/Browser” activity?
@seki_i yes you can pass it to on the Browser Activity But first check what happen if you pass that copy word from the excel in the browser do it manually has it open the browser .because has that word is in valid form that treat that word as a browser content .try it and check what results you are getting
I just assigned the value to a variable individually and executed it, and the URL variable part was correctly set to the value of the specified cell.
okay like this
Thank you.
Thanks to your advice, I was able to resolve the issue.
@seki_i your welcome glad to see your query has been resolve happy learning keep automating.
cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
