Hello people!!
I have an excel DATA.xlsx (8.7 KB) where it has many columns, like
Where my requirement is to Concatenate every Name and Pan ID and add a “-” between them like “MANJEET-123456” and this string is a name of a pdf file in a particular folder.
I need to open every file that matches the Concatenation we done.
Thanks in advance!!!
Hi @Rakesh_Sampath
U can do this way
Read the excel file and store in dt1
Use for each row to loop through each row of dt1
Inside the for each row do the following:
Use assign activitiy to do the following
name= row(“NAME”).ToString.Trim+“-”+row(“PAN ID”).ToString.Trim
Then use path exist to check whether the path is existing
Like consider path as
C:\Users\output (folder in which PDF files are there)
Now use path exist activitiy to check whether the path is existing or not by providing input as
“C:\Users\output"+name+”.PDF"
and store the results of path Exist in a Boolean variable let’s say path_exist
Next use if Condition with condition as path_exist
If it is true , in then section do the following
a) Open the file
b) do the necessary actions
c) close the file after usage
If the condition is false ( ie file with Name-PanId is not there)
Then do accordingly in else section.
Hope it helps you
Mark it as solution if it resolves ur query
Regards
Nived N
Happy Automation
1 Like
system
(system)
Closed
February 4, 2021, 6:36am
3
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.