Help! Check if a folder contains Excel

Learning Hub Academy Feedback
, ,
1

Hi developers!

I’m beginner of the uipath and I have encountered the following question;
I want check if a folder contains Excel file, which is .xlsx, .xls or .csv format, and then save those Excels to another folder. How can I do it? how to exclude those pdf or word but to keep the excel file.

Pls give me some ideas. Many thx

1 Like
2

you can loop through the folder and get only extensions, and use conidtion to move the file to another folder!

3

hi @mason_wong,

Below is a custom activity to separate Data as per extensions.

–
Mukesh

4

hi mukeshkala,

Appreciate your sharing. But i failed to open the download package> Do you know why?

5

hi @mason_wong,

You would have to import the package from Studio.

image
image901×499 51.1 KB

Post that you will get the same in activities

image

–
Mukesh

7

Thx mukeshkala,

Yes, it works. but any possible that I can read the detail steps you have built to handle the files?

8

hi Samir,

Looking forward to your sharing

9

MoveFilesFolder.zip (23.2 KB)

Attached is the Source Code.

–
Mukesh

10

Well received. Thx mukeshkala