In Refrmework queue project how to write Successful, business, System exception status in excel with queue transaction

In Refrmework queue project how to write Successful, business, System exception status in excel with queue transaction

@Garyy

Hi @Garyy

use the write cell activity in the specific place like after the process states there are success , business and system exception paths will be appeared so use the write cell activity in those place accordingly.

Regards

Hi @Garyy

Please look into this

The following thread might be helps you

I hope it helps!!

Hi @Garyy

In Process transaction you have the Invoke workflow, open that workflow in that you have the sequences success, business and system exception. Open that sequence and place the datatable activities in that sequence.
image


In those sequences give the add data row activity which add the rows to the datatable.

At last, Open the end process and use the write range workbook activity to write the datatable data to excel.

Hope it helps!!

@Garyy

You can use append range activity in the set trasnaction status xaml…and write the datatable

And use add data row and build datatable to build and add required row after eqch transaction is compelte…so new row is appended

Cheers

Hi @Garyy

Check this:

Hey @Garyy ,
Please refer below XAML for reference
SetTransactionStatus.xaml (43.8 KB)

So basically all the status are written into a variable and then a separate sequence is created where that variable is added and appended to Excel