How could get all excel files in a folder except one excel with special name

[Chris-Yiwei (Ji)]

dear all,

in one folder, for example there are three excel files, named 1.xlsx , 2.xlsx and master.xlsx.

i used directory.getfiles(path, “*.xlsx”) to to get a string but i dont not want contains the master.xlsx just 1.xlsx and 2.xlsx , how could i achieve this function?

anybody could give a guide ?

thanks a lot in advance

[venkatmalla6 (venkat malla)]

@Chris-Yiwei even though you get all those files you can filter by using if condition inside the for each loop,say for example as you said there are three files out of that you want only two,so inside the for each loop you can give if condition like item which contains master if it finds it went to then if not else,so to the else condition other two files will come.have a try this

[lakshman (Ganta lakshman)]

@Chris-Yiwei

Try this expression:

directory.getfiles(path, “?.xlsx”)

Just replace wild card star “*” with question mark ? And then try.

[Chris-Yiwei (Ji)]

i used this directory.getfiles() it will collect all the xlsx files, but i want to excluse one special excel file

[lakshman (Ganta lakshman)]

@Chris-Yiwei

Just try the above expression and it will skip master file and will give remaining files.

[Chris-Yiwei (Ji)]

i used directory.getfiles(path, “master.xlsx”) the output file is only master.xlsx but i do not need master.xlsx just need 1.xlsx , 2.xlsx

[lakshman (Ganta lakshman)]

@Chris-Yiwei

I said try this one:

directory.getfiles(path, “?.xlsx”)

[Chris-Yiwei (Ji)]

i print the result , it is empty directory.getfiles(path, “?.xlsx”)

[Palaniyappan (Forum Leader)]

Hi
Kindly folllow the below steps that could help you resolve this
—use as assign activity like this
Out_Filepatharray = Directory.GetFiles(“yourfolderpath”,”*.xlsx”).Where(name => !name.EndsWith(“Master.xlsx”))

Or by this mean as well @Chris-Yiwei
Out_Filepatharray = Directory.GetFiles(“yourfolderpath”,”*.xlsx”)

Out_filesToExclude = Directory.GetFiles(“yourfolderpath",”*.xlsx");

Out_wantedFiles = Filepatharray.Except(Out_filesToExclude);

Cheers @Chris-Yiwei

[Palaniyappan (Forum Leader)]

@Chris-Yiwei
Were we able to get the correct files
Cheers

[Chris-Yiwei (Ji)]

@Palaniyappan

Filepatharray.Except(Out_filesToExclude)

what is the type of variable Out_Filepatharray , Out_filesToExclude and Out_wantedFiles.
i use this approache , compile error

[Palaniyappan (Forum Leader)]

All should be string array

[ViswanathanAM]

Do we need to Assign 3 activity??

[Palaniyappan (Forum Leader)]

Hi
Welcome to uipath community
Kindly come again
I didn’t get that
Cheers @ViswanathanAM

[ViswanathanAM]

Thank you for your warm welcome !!

do i need to create 3 assign activity??

Out_Filepatharray = Directory.GetFiles(“yourfolderpath”,”*.xlsx”)

Out_filesToExclude = Directory.GetFiles(“yourfolderpath",”*.xlsx");

Out_wantedFiles = Filepatharray.Except(Out_filesToExclude);

i tried as per the above but i am getting error message !!

could you pelase share your xmal. file. so that i can easily verify with your assistance

[ViswanathanAM]

Hi All,

I have made small workflow in that if I print the value. Its printing without the data.

please find the attached screen shot for your reference.