REad a Location From A Excel

Help
1

I want To Read A Location From A Excel And I Want to Go to the Location as Step By Step

Screenshot%20(77)
Screenshot%20(77)1366Ă—768 87.5 KB

I want to do step by step move to the Location Urjent Can Any One Help Me

2

@Palaniyappan

1 Like
3

Hi
usually filepath will be having backslash right
but in the excel all the file path are having forward slash, is that right first
kindly copy and paste it in your file explorer - file path bar
or
is it a URL

Cheers @Karthikeyan34

4

Fine as of now
let me tell you the steps to be used to go to these file location one by one
–use a excel application scope and pass the file path as input
–inside the scope use a read range activity and get the output with a variable of type datatable named dt
–now use a for each row loop and pass the above variable dt as input
–inside the loop use a send hot key activity with key as WIN+r
–followed by that use a type into activity and mention as row(0).ToString so that the FILE LOCATION will be typed here
–then use a send hot key with enter as key which will take us to the file location
–we can have a sequence with set of activities to be done in that location
or leave it as it is so that for each row loop will open all the file location one by one in sequence

hope this would help you
kindly try this and let know for any queries or clarification
Cheers @Karthikeyan34

5

@Karthikeyan34 From your image I can see that there are files of different types you want to read them??

6

Thanks @Palaniyappan its a Url I want to search this location in a Application It can be done only by step by step i cant Paste and there is no search box to search the location So kindly help me with this

7

Also In For Each row Loop I Passed the Dt and After that How I Can Get the Values in the column @Palaniyappan

1 Like
8

Great
once after getting the datatable dt
we can get the value of that column with a ASSIGN ACTIVITY like this
str_URL = row(0).ToString

then we can use that string variable str_URL as a input for OPEN BROWSER activity

Cheers @Karthikeyan34

9

Retail_Samples/Charts/Bar_Chart_Highest_Margin_Products.fex
I have Url Like this But Initially I want to Split this Like
1.Retail_Samples
2.Charts
3.Bar_Chart_Highest_Margin_Products
With this url i will go the application in that i want to click each of this things in a path and want to click the select

10

so you want to split them
and to do that
arr_str1 = Split(str_URL,“/”)(0).ToString
arr_str2 = Split(str_URL,“/”)(1).ToString
arr_str3 = Split(str_URL,“/”)(2).ToString

now we can use click activity with these variables passed along the selector as a variable to the attributes like this
suppose aaname is the attribute then the variable must mention mentioned as
aaname = ’ " + arr_str1.ToString + " ’

Cheers @Karthikeyan34