I am creating a project where you should be extracting attachments (excel files) from outlook and save it in a folder so later on you can edit them and do other tasks. Well, I have downloaded the attachments and saved them in Attachments folder by their Employee IDs ( a folder which contains excel files for that particular employee) but the problem is that I have to now iterate through the Attachements–>EmpID–>Excel files to read each excel file in order to do some sum and other tasks. How do I achieve this?
We can use a simple assign activity to get all the excel files from we want in specific
The steps involved are as follows
—use a assign activity like this Out_filepath = Directory.GetFiles(“yourfolderpath”,”*.xlsx”)
Where Out_filepath is a variable of type string array
—now use a for each loop activity and pass the above variable as input and change the type argument as string in the property panel of for each loop activity
—now use a excel application scope and mention the filepath as item which is the variable from for each loop which will have the file path we want
Hi @Palaniyappan, that works. I forgot to mention that ed1 is not constant. I have saved folders by employee id’s. how do I attain this. I have saved ID’s in a variable and tried using that as follows but doubtful if it will work: