Hi. I want to this
If there is an excel file in the folder, read the excel. Else don’t do anything
How can I do that?
1 Like
Hi @sufyant
Use Strarray=Directory.GetFiles(inputfilepath)
use for each item in strarray
in if condition item.ToString.Contains(“.xlsx”)
use read range else give message log message for dont do anything
Thanks
Ashwin S
1 Like
Hi @sufyant
Use Excel application scope activity pass the path of excel file inside use read range activity pass the sheet name and create output data table variable.
Regards,
Kommi Jeevan.
1 Like
I do not understand
Hi @sufyant,
You can use the below statement in an assign to get a list of excel files.
Directory.GetFiles(FolderPath, “.xlsx”).ToList
You can loop for the list and read the excels using Read range activity.
1 Like
hey @sufyant
you can do this
ArrayVariable = Directory.GetFiles(sourcePath, “*.xlsx”)
this will fetch you only Excel File
Cheers
1 Like
HI
hope these steps would help you resolve this
–use a assign activity like this
arr_filepath = Directory.GetFiles(“yourfolderpath”,“*.xlsx”)
where arr_filepath is a variable of type array of strings
this will give us all the xlsx files alone from that folder to this variable arr_filepath
–now use a IF condition like this to validate whether there is any file in the folder or not
arr_filepath.count > 0
if true it will go to THEN part where use FOR EACH activity and pass the variable arr_filepath as input and change the type argument as string
–inside the loop use a EXCEL APPLICATION SCOPE and pass the input as item.ToString and inside that scope use READ RANGE activity and get the output with a variable of type dattable named dt
Cheers @sufyant
1 Like
(“filepath"+”+ilanAdi+" “+tarih+”,“*.xlsx”)
1 Like
1 Like
May i know what is that ilanAdi and larith
is that a variable
even though if its a variable a folder path or a filepath wont have space in it
probably it would be like this
Directory.GetFiles(“youfolderpath…Candidates\”+“ilanAdi”+“_”+“larith”,“*.xlsx”)
or
Directory.GetFiles(“youfolderpath…Candidates\”+“ilanAdi”+“larith”,“*.xlsx”)
Cheers @sufyant
1 Like
//missed out * here
Directory.GetFiles(FolderPath, “*.xlsx”).ToList
1 Like
yes there are variable
1 Like
then try with either of this, because there would be no space between filename or folder name
but anyhow if its there lets validate this once
use writeline activity and mention this folder path alone
like this
“youfolderpath…Candidates\”+“ilanAdi”+“_”+“larith”
copy that and paste in file explorer so that we can check whether it takes us to the folder or not
Directory.GetFiles(“youfolderpath…Candidates\”+ilanAdi+“_”+larith,“*.xlsx”)
or
Directory.GetFiles(“youfolderpath…Candidates\”+ilanAdi+larith,“*.xlsx”)
Cheers @sufyant
1 Like
@Palaniyappan i’m sorry if im wrong variables declared like this right ??
“+StrVariable+”
tell me if i’m wrong!
2 Likes
Yah modified
you are correct
@Pradeep_Shiv
2 Likes
Anil_G
Nidhi_Gupta1