Summary Report in Excel

[Vikram212 (Vikky)]

Hi @Florent_Salendres

in a RE framework when we create Report related to Business Exception and Application Exception

Can we also create Summary Report in same spreadsheet which contains
Total Number of Business Exceptions - X
Total NUmber of Appliction Excepton - Y
Total NUmber of Successfull data - Z

How can we build logic regarding this
Sorry, i know i am sounding foolish to ask

[Raul8 (Raul Ortiz)]

Yes, create a table with following info and later with write range choose the correct range “X:Z”

[Shubh1801 (Shubham Pratap)]

Yes, We can do it .
Considering you are using default Template of REFramework provided by UiPath,
Create a excel file with all fields required for you case consider
Total Number of Business Exceptions 0
Total NUmber of Appliction Excepton 0
Total NUmber of Successfull data 0
Where A Column of Excel file hold description and B Column holds count.
Now in,
In SetTransactionData WorkFlow,
Case of Success=> (After setting transaction status sucessful) Read the value of cell “B3” > Convert it to int and then increment its count by 1, again use write cell activity with new value in cell “B3”

Case of Business Exception => (After setting transaction status Failed due to business Exception) do the same for cell “B1”.

Case of Application Exception => (After setting transaction status Failed due to Application Exception) Note: Make sure you increment for this case once all retry options are completed.

Please feel free to ask more details if required, Needed i can build you a .xmal file for it.

[Vikram212 (Vikky)]

yes it would be really helpful @Shubh1801 if you can show in xmal file
Many Thanks

[Shubh1801 (Shubham Pratap)]

Please find project in .zip file
I have used Assign activity to set Exceptions.
Please let me know if more details are required.
TransactionLogs_in_Excel.zip (17.7 KB)