How to extra filenames and check these files exists in excel if not it should enter file name in the excel

Help Studio
1

Can anyone help me how to extract file name with extension from a folder and check extracted file name in excel. if not exists then it should enter the file name in Column A and in column B update as “Pending” please refer my screen shot below.

image
image1399×790 77.6 KB

image
image856×652 28.1 KB

I don’t know how to write condition for this pls help me

2

Hi @tkiran ,

Kindly refer to the attached SolutionCheckWhetherFileNameMatches.zip (8.9 KB)

3

File extract.xaml (15.9 KB)
i have tried but some where i am missing can u pls help me out i have attached file

4

The code looks fine, what is the issue you are currently facing.

5

image

6

image

7

In the code shared with me there is no such errors

image
image1208×805 25 KB

Click on edit arguments and check whether you have created PDT and binded it as well.

8

image
image1029×289 9.38 KB

pls check this arguments

9

Looks fine, check whether Private property is set.

10

Well, My approach would be bit different.

  1. Read excel file in a DT.
  2. Get file from folder in a list
    listFile=Directory.GetFiles("FolderPath")
  3. for each item in listfile
    if((from dr as datarow in DT where dr.item(“Column A”).ToString.Contains(path.GetFileNameWithoutExtension(item.ToString)) select dr).count>0)
    {
    }
    else
    {
    Add data row ({path.GetFileNameWithoutExtension(item.ToString),“Pending”})
    }
11

File extract.xaml (18.7 KB)

Can you pls correct in this if possible or send me your above code in uipath screenshot.

1 Like
12

File extract.xaml (9.7 KB)

Here we go

13

WOW… Superb… thank you so much it works perfectly…

1 Like
14

@tkiran Great it helped you.
Please mark it as solution and close thread.

15

Hi @Lakshay,

Good to know about your though!
The logic is still the same, the only difference here is parameter is interchanged & loop is avoided since it might affect performance.

1 Like
16

@shivagowdavarad True that. Logic is exactly same, just another way of doing it.

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.