Validation of For each file Name and data in the DT

Help Studio
1

Hi,

I have an excel file where I have stored the invoice file names and I have invoice files in a folder.

Now I want to validate the files with the names in the excel. If the names and files matches(exists) then I want to append to “Yes” against the Name in the excel, if not append “No”.

can anyone please provide the solution for this.

Thanks in advance

2

Hi @raju_alakuntla

Can you try below

The image depicts a sequence in UiPath automation workflow that reads a range from an Excel workbook, iterates through each row to evaluate a condition, updates the status column based on the condition result, and writes the updated data back to the Excel workbook. (Captioned by AI)
The image depicts a sequence in UiPath automation workflow that reads a range from an Excel workbook, iterates through each row to evaluate a condition, updates the status column based on the condition result, and writes the updated data back to the Excel workbook. (Captioned by AI)818×1378 46.2 KB

System.IO.Directory.GetFiles("C:\Users\lrtetala\Documents\UiPath\BlankProcess23\Input").Any(Function(file) System.IO.Path.GetFileNameWithoutExtension(file).Equals(CurrentRow("FileName").ToString))

Input:

A spreadsheet with two columns titled "FileName" and "Status," listing item names under "FileName" but leaving the "Status" column blank. (Captioned by AI)

The image shows a File Explorer window open to the directory "This PC > Documents > UiPath > BlankProcess23 > Input," containing two Excel files: "ConsolidatedSheet" and "Worksheet1," with their respective sizes and modification dates. (Captioned by AI)
The image shows a File Explorer window open to the directory "This PC > Documents > UiPath > BlankProcess23 > Input," containing two Excel files: "ConsolidatedSheet" and "Worksheet1," with their respective sizes and modification dates. (Captioned by AI)1119×269 14.7 KB

Output:

The image shows an Excel spreadsheet with two columns labeled "FileName" and "Status," containing a list of files with their corresponding status marked as either "Yes" or "No." (Captioned by AI)

Regards,

1 Like
3

@raju_alakuntla

As you need the status on excel instead of reading and doing on datatable and writing use for each row in excel so that the status gets to excel directly

cheers

4

Step-1: Read excel file into a data table
Step-2: Store invoice filenames into an array of strings
Step-3: for each row in data table
if arr_InvoiceDetails.Contains(row(“File”).ToString),
then writecell status as “yes”
else writecell status as “No”

Attached is the solution for your reference.
FindInvoiceName.zip (510.1 KB)

5

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