Hello Wonderfull People,
Please I need your help again.
You will find the picture below
I saved an email Excel attachment in a folder and the name of the attachment in a variable . Then, i use an If activity to verify if the attachment extension is (.xls or .csv). If conditions are true, then i want to change the attachment extension to .xlsx. To do that, i am using a excel proces. please look at the picture below.
Once after verifying with if condition whether it is csv or xls file it goes to then block where use a SAVE ATTACHMENT activity and pass the mailmessage variable as input and folder path where u want to save the file
Repeat the same for all mail messages
Once after saving all the files in that folder now use a Assign activity like this
Where arr_filepath is a variable of type array of string
Now use a for each activity and pass this array variable as input
And change the type argument as string
Inside the loop use a MOVE FILE activity and pass the source filepath as item.ToString and mention the destination filepath like this
This will change all the valid files and it’s file path with xlsx extension
Is the Expression Editor path well adressed? Please consider that my intention for the Attach_name variable was store the name of the attachment in this variable just to use it when i wanted to save it again but with the new extension (.xlsx). What is more, i think that “Save Excel File AS” activity will change automatically the extension …