Get only .xls file from the folders

Help
1

I have the tree folder structure, where I have the main folder which is Export and inside it I have 4 folders like Invoice01…, Invoice02…like that.
But inside these folders and I have some file which is in the image and excels format and one folder inside it which contain one excel file. But i want to move this excel file from the folder Invoice01…, Invoice02…like these
Can anyone tell how can I get only excel.
image

2

Buddy @balkishan

You can get the xlsx files alone from a folder pathby using this
out_file_array = Directory.Getfiles(“YOURFOLDERPATH”,“*.xlsx”)
where out_file_array is of type array

Cheers @balkishan

3 Likes
3

@Palaniyappan, I have another folder inside this folder
image

But I need only extracted_information. Here is the question is the name of the csv is same in all the folder as extracted_information. So I thing I have to used timestamp right me if I am wrong, or any other method to do this. To collect all the extracted_information file from all the folder I want to save in particular folders.

4

Buddy sorry i didn’t get you, i mean like which one you want the file extracted_information or you want to open the folder extracted_information and get the files from it

Cheers buddy @balkishan

5

@Palaniyappan If you see this bro here is the tree structure.
Export is the root folder
where there are 4 folders name Invoice01…, Invoice02… like that

Again if you see inside the folder Invoice01… → extracted_information (Folder)
extracted_information (CSV File)
Invoice01 (Image)

If you see bro, folder Invoice01… containing the three files include the csv right? same three files with same name in all the three folders Invoice02…, Invoice03… & Invoice04.

Now I want to copy the extracted_information csv files from all the folder and save in one folders. Hope you got it :slight_smile:

image

6

Hello,
Can you try this?
array_directories = Directory.GetDirectories(“yourPath\Export”)
And then use For Each and find the xlsx file in each subdirectory(Invoice0X.tif…) and move this file?

1 Like
7

Buddy @balkishan

This can help you buddy
https://go.uipath.com/component/directory-subdirectory-file-search#

Cheers

1 Like
8

@Palaniyappan Thanks will try bro :slight_smile:

1 Like
9

Kindly try and let know buddy
@balkishan
Cheers

1 Like
10

@Palaniyappan Bro I’am able to fetch these files, but can you tell me what to put in the Output- FilePath— As I give the folder path where I want to store these files, but it’s not taking. can you tell me where did I mistake
image

If I give the direct path it’s showing me this error

image
image853×183 10.7 KB

or If press ctrl+k and create a new Variable and set this path in that Variable same error it’s giving me that time. So what exactly we need to set here

1 Like
11

Change the type buddy to string as list buddy and initiate with default value as
new list (of string)
@balkishan

1 Like
12

@Palaniyappan same error it’s showing me bro, when I change the type from List to string

image
image838×190 8.69 KB

1 Like
13

buddy infolder is of type string i think, kindly change it to list and change the scope in variable panel as well @balkishan

1 Like
14

Like this bro

image
image868×41 3.31 KB

Previously I changed to String only.

1 Like
15

in default value put like
new list(of string)
buddy @balkishan

2 Likes
16

image
image844×60 2.68 KB

you want to say like this bro?

17

NO buddy simply new list(of string) that means list created of string type values
Cheers

2 Likes
18

Now the error is removed bro, So can you tell me is there any activity to copy/move this file and save in a particular folder.
image

19

I did like this bro.
image

But giving this error
image

20

Buddy it would give you list of paths as output with which you can you can get the xlsx file alone.

1 Like