How to create an summarized report

Help Activities
1

After finishing my process, I want to add all my processed records in 1 summarized report in excel and erase the previous day’s data and send an email to admin everyday.

How can this be achieved?

2

@automated

If you are usign re framework in the end process or if you are not using it then at the end of all your transactions , you can include the logic to get all the current day added items using get queue items activity and filters in it and can add to excel and send email…

Cheers

3

I’m using reframework and still new to UiPath.
What activities should I use and should I write logic in closeAllApplications or in the process.xaml
Kindly guide.

4

@automated

You should arite the logic in end process state…

Basically you gave to use get queue items activity and in properties you have filter on date which you can use to get data for todays date…

Then use for each activity and loop theough each queue item and use add datarow to create a datatable

And at end use write range to write to excel

Cheers

5

Thank you for the help.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.