How to get filepath based on specific keyword

Help Activities
, ,
1

Hi Team,

I have one excel, this is excel have more sheet for ex 4 sheet

In folder filepath having with sheetname , i want to pass sheetname once sheetname contain filepath, i need to pick that path.

Please help me anyone for this.

Input:

The image shows an Excel spreadsheet with data in columns A, B, and C, and four highlighted sheet tabs at the bottom labeled "Abc," "uuu," "xyz," and "vvv." (Captioned by AI)
The image shows an Excel spreadsheet with data in columns A, B, and C, and four highlighted sheet tabs at the bottom labeled "Abc," "uuu," "xyz," and "vvv." (Captioned by AI)517×770 14.1 KB

expected output:

The image shows a file explorer window with two Excel workbook files named "Book-vvv.xlsx" and "Book-xyz.xlsx" in a folder titled "New folder (2)" under the "Documents" directory. (Captioned by AI)
The image shows a file explorer window with two Excel workbook files named "Book-vvv.xlsx" and "Book-xyz.xlsx" in a folder titled "New folder (2)" under the "Documents" directory. (Captioned by AI)780×457 13.4 KB

Path :
“C:\Users\Raja\Documents\New folder (2)\Book-vvv.xlsx”
“C:\Users\Raja\Documents\New folder (2)\Book-xyz.xlsx”

2

Hi @Raja.G ,

Can you please elaborate what exactly is your question.
Are you trying to read the sheet from the first input file based on the file present in New Folder (2)?

3

image

image
image1249×1603 99 KB

image

image

4

Hey @Raja.G your question is quite confusing. as per my understanding . if you have multiple Excel Sheets and you want Specific Sheet from the Sheets. you can check with these 3 activity

This image shows a UiPath workflow that checks if a specific sheet ("Sheet1") exists in an Excel workbook ("Dataonfig.xlsx") and writes "Found" if it does, otherwise writes "Not found." (Captioned by AI)
This image shows a UiPath workflow that checks if a specific sheet ("Sheet1") exists in an Excel workbook ("Dataonfig.xlsx") and writes "Found" if it does, otherwise writes "Not found." (Captioned by AI)919×471 25.8 KB

Cheers Happy Automation.

5

Hi @Raja.G ,

You may try the following solution:
Step1: use “Excel application scope” activity to read the excel file and drag “Get workbook Sheets”. it will store all the sheets in a list of strings.

Step2: For each loop, Directory.GetFiles(“FolderPath”)
Step3: in the same container, use an if activity with the condition:
mySheets.Any(function(f) file.Contains(f))

This image depicts a flowchart in UiPath Studio, illustrating the process of opening an Excel file, retrieving its sheets, and checking if files in a specified directory match certain conditions, displaying a message box if they do. (Captioned by AI)
This image depicts a flowchart in UiPath Studio, illustrating the process of opening an Excel file, retrieving its sheets, and checking if files in a specified directory match certain conditions, displaying a message box if they do. (Captioned by AI)552×726 36.1 KB

FilePathFinder.xaml (11.7 KB)

Please refer to the attached solution and let me know if it works.

Thank you,
Anjani

1 Like
6

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