Assigning a value taken from one excel to a folder?

Help Studio
1

I have an excel file which has team names in it and I have to select one team and go to that particular team folder and read an excel file from that specific team folder and I have to do the same for other teams aswell. As I am a beginner in uipath please help me with this. Thanks in advance.

2

@sairama.deepthi

For Reading value from Excel, you can refer as below

After placing For Each row as suggested in video, you can place Read Range activity again and specify the path which you get from excel

Hope this helps you

Thanks

3

Thanks srini for the solution. I am able to get the folder name. But how do I pass the name I retrieved from excel file to readrange as folder path

4

I am using directory.getfiles(“E:\xx\abc"folder name retrieved from excel sheet,”.xlsx").
Is this correct?

5

@sairama.deepthi Assuming that All your Folder Names (Team Names) are in the Folder "E:\xx\abc", Most Probably the Below expression should help you in retrieving the excel file from that Folder.

listOfFiles = Directory.GetFiles("E:\xx\abc\"+ folderName ,"*.xlsx").ToArray

Where listOfFiles is a variable of the type Array of Strings, which means that it will hold the Collection of excel file paths present in the mentioned folder, and folderName is a variable of the Type String, also assuming that the folderName value will be the Value that is read from excel file which has Team names in it.

To Access the First Excel file from the Folder, You can directly get the file using the below expression :

teamsExcel = Directory.GetFiles("E:\xx\abc\"+ folderName ,"*.xlsx")(0)

Where teamsExcel is a String variable, and it will hold the full path of the Excel File present in the Teams folder name that was retrieved.

However There would be a case to handle the error that will occur when you do not have an Excel File in the Folder.

We can handle that particular error using an If Condition to check if the Files Exist at first, then retrieve the file path.

Let us know if you need more clarifications.

6

Thank you so much for detailed explanation. Will try and will update you if I am able to do it or not.

1 Like
7

@supermanPunch it’s working. Thank you.
@Srini84 thank you.

1 Like