Copy all the files name then put it into excel file uipath


#1

hi,
in my local pc there are are some files, I want to copy all the file names one by one then paste it into an excel or CSV file. How can i do that?


#2

Hi @ArafatRakib1
1.Launch the folder
2.click the folder using click activity
3.use ctrl+a and ctrl ctrl +c by using send hot key
4.use excel application scope and give the excel path and give ctrl v


#3

first of all thanks for your response. i am newbie to uipath rpa, could you please explain in more details, or show me an example? how to launch a folder in uipath?


#4

Check this,

Files.xaml (9.2 KB)

Thanks,
Rammohan B.


#5

thanks, and i need only the file name not the filepath. could you please solve it?


#6

HI @ArafatRakib1

1.USE SEND HOT KEY AS WND+R
2.USE TYPE INTO AND MENTION THE FOLDER NAME WITH THE ABSOLUTE PATH

tHANKS
ASHWIN s


#7

Check this. It would give only filenames.

Files.xaml (8.7 KB)

Thanks,
Rammohan B.


#8

hi, again thanks and is it possible to get only the file name, not the file type extensions(jpg,pdf,rar,etc). Could you please help me? @Rammohan91