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: <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/f/e/7/fe78ec18a69a4c03a6a1f0c6f8af4cadac37398a.png" data-download-href="/uploads/short-url/AjalPWqTKDWLqE7VAZG5cN22iZc.png?dl=1" title="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)" rel="noopener nofollow ugc">[The image shows an Excel spreadsheet with data in colum…

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 …

How to get filepath based on specific keyword

Help Activities

rashmisingh2695 (Rashmi) October 5, 2024, 1:54pm 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)?

Topic		Replies	Views
Read excel sheet with different name Help excel , activities , question	14	1194	January 6, 2020
How to search a excel file in a folder and read that file Activities excel , activities , question	17	2869	February 23, 2022
Correct Sequnce Activities excel , activities , question	21	528	July 5, 2023
Read Specific Range in Excel then move file if it contains specific word Help excel , activities , question	37	2062	November 6, 2019
Read specific keyword name files from folder Activities excel , activities , question	4	528	February 13, 2023

How to get filepath based on specific keyword

Related topics