How to create an excel template having the results of your automation

Help
1

Hi Team,

I am in the process of creating an excel template which is having the results of my automation process.

As per the attached screen shot, Here is my automation process steps followed:

  1. Login to the web application
  2. Filter Process 1 with Yes. Navigate to Process 1 screen and download file for each search record and continue the same process for till the last search record
  3. Same for Process 2 and Process 3 as well.
  4. Whenever there is no file to download then we need to take screen shot.
  5. Even though we are using ReFramework for this automation , not using queue concept because of some limitation

I need to update the excel file after each search record in Process 1 till the last record, then Process 2 and Process 3.

Could you please share your thought process on this? Please suggest the steps on how to implement this process. Any xaml file which suits this requirement will be helpful.

Thanks for your valuable time and support.

2

image
image854×96 87.3 KB

3

Hi there @katakam26

Here is how you can do it easily…

As you have many processes (Process1, process2…) you can use transactions arch. ( use queueing) and then have as many status update columns as you like (any info you need in your report) and keep on updating them with your values depending on the outcome of the singular process in that iteration (update queue/transaction item) and then fetch all queue items and write to excel.

Hope this helps :slight_smile:

PS : Instead of building your own flow you can use the RE framework that comes as a template with the UiPath project. Get back to me if you have any questions.

4

@ Raghavendraprasad, I am sorry that I forgot say that we are not using queues.