How can create variable If folder is empty files

[Abubakkar (vnrabu)]

Hi experts,

I have issue with write condition. for example
if folder have some excel files then delete all files
else continue process
how can i identify folders is empty or excel files?
could any one help me please?

Thanks
Abu

[AshwinS2 (Ashwin S)]

Hi @Abubakkar

Files=Directory.getFiles(InputFilePath)
and pass this into a string variable
and use path exists activity based on the condition do the manipulations

Thanks
Ashwin S

[indra]

@Abubakkar

1. To check folder is empty use this in assign activity strarray =Directory.GetFiles(“directory path”)

If(strarray.count=0)
{
//Folder is empty
}

2. To check excel file

For each item strarray
{

If(item.ToString.Contains(“xls”)
{
//delete excel
}
Else
{
// continue process
}

}

[aman_sheik]

@Abubakkar Array.ForEach(Directory.GetFiles(@"c:\MyDir"), File.Delete);

[Abubakkar (vnrabu)]

Thanks @aman_sheik
where can I apply it ? Assign activity or If condition?

[aman_sheik]

@Abubakkar

Take Invoke Code Activity and in arguments create Argument(“String”)i.e., Your Path

in code write : Array.foreach(Directory.GetFiles(Path),Sub(x) File.Delete(x))

For your reference check below code

DeleFile_Ifexists.xaml (4.4 KB)

Hope this helps!!!

Thanks,
Aman Sheik.

[Abubakkar (vnrabu)]

Thanks buddy .
how to copy excel files and paste another folder?
which activity should I use?
could you help me please

[aman_sheik]

@Abubakkar

You can use copy file acivity

Thanks,
Aman Sheik.

[Abubakkar (vnrabu)]

Thanks buddy @aman_sheik

[Abubakkar (vnrabu)]

I got the error
“the target file directory is not a file”

[Abubakkar (vnrabu)]

Exception type : system.IO.IOException

[aman_sheik]

@Abubakkar

Where you got this error in copy file Activity???

[Abubakkar (vnrabu)]

Yes buddy

[Abubakkar (vnrabu)]

i want to copy “macro excel” file and paste it another folder
that’s it

[aman_sheik]

@Abubakkar

You have to give your source and destination path like this

Thanks
Aman sheik