I want count of total no. of transaction written in separate excel

I want to know of all combined transaction is run every single time.

For eg


I want the count of all the count in separate excel.

Transaction Count
This second excel will be password protected as well
So that we will know who was run the process how many times.

Hi @Bhushan_Nagaonkar

  1. Use read range activity to read the excel and store in an DataTable.
  2. To get the count of No. of rows in the excel use the syntax:

DataTablevar.RowCount / DataTablevar.Rows.Count

Print it using an writeline activity or message Box.

Hope it helps!!


1 Like

Im using reframework. How should I use for RE-Framework

If you’re using RE Framework,
Your transaction type would be of type DataRow,

You can write the count in the Final State or in the Init State itself by reading the range from the input Source File.

1 Like

can you share the flow?

If Im not wrong

I have to assign value to Transaction Item ie Datarow.Count

You can put it here in End Process like this:


I dont want to overwrite it should append

Can you share your expected output?

And sorry my bad in the second write cell it should have been A2 as Cell

Hi @Bhushan_Nagaonkar

Instead of using Write Cell try using Append Range to append the data.

Hope it helps!!


The process will be run n number of times.

For eg
On Day-1
3 transactions
Day 2
4 transactions

So it should append.

Keep your excel file at some shared location.
Use Build Data Table : dtRecords with one column TransactionCount
add Data Row : Pass {dt_TransactionData.rowCount.toString} in ArrayRow and in dataTable: dtRecords.
Use Append Range activity to add records one after the another.

My suggestion would be to add a second column while Building DataTable with TransactionDate
in Add Data Row you should pass {dt_TransactionData.rowCount.toString, Now.ToString(“dd/MM/yyyy”}


1 Like

I do need second column for name who has used the script.

Thankyou for your time and efforts. I’ll check and let you know

@adiijaiin Can you share your workflow. im making some mistake

Hi @Bhushan_Nagaonkar ,

which UiPath version are you using?

I did share a xaml before was that opening?

If so I can edit and reshare.


hi @Bhushan_Nagaonkar

I have modified the workflow and attaching for your reference along with the output generated:
testdata.txt (1.4 KB)
CustomerData.xlsx (7.5 KB)
JSONData.xaml (13.9 KB)

I will just check and let you know,


Im using 2023 latest

hi @Bhushan_Nagaonkar

Did you check this workflow?

You built a data table for it, you stored the value.

In this way we can use for reframework as well. I just have to increase the count


we can do it.

Hope this has helped you out.


1 Like