Renaming file based on information from Excel

Help StudioX
1

Hello,

I am pretty new to StudioX, I’ve only build a few bots with it. Now I’m struggling with one.
Here’s my problem:
I have about 500 files (png) that need to be renamed. The current name contains the employee number. Instead of the employee number, the filename needs to contain the employee name.
I have an Excel file with the employee numbers in column A and the employee names in column B.
Is it possible to create a bot that finds the employee name associated with the employee number, and add the employee name to the filename of the png?

2

it would be great If you could share a sample data and screenshot of the PNG file names …

3

@AngelaB - Here you go…

image
image252×671 24.7 KB

My PNG files before Renaming…

image

Excel File with Employee Details

image

Final Output

image

XAML File:
RenameFile_BasedonExcel.zip (186.3 KB)

Hope this helps…

2 Likes
4

My hero! Thank you so much, it worked!
Next time I’ll make sure to share a sample data.

1 Like
5

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