Automation script

excel
uiautomation
email
activities

#1

hello guys, i want to extract some data from excel sheet dynamically (data will change daily) and post it to email to mail someone, i am working on pulover’s macro creator tool, can anyone help on this???


#2

It can be done using UiPath excel and email activity.

You open the excel file stored at a location
(Say /input folder) (use excel scope)
extract the required fields. (read cell an excel activity)
Store those in required file. (Write activity)
then send that using email functionality

To run the above code dynamically -

Use Orchestrator scheduler to run automatically.
Write a UiPath program that will
pull the new excel file
delete the old file
(while deleting file keep the ContinueOnError property true)
and store the new file at the fixed location.
(/input folder)