Hi There,
I have a output excel with 10 columns and also with 2 empty columns with headers for the report.
At the end of each row transaction i need to update the output excel with the process status and output in those output columns. For that i have to first identify the row index of the particular transaction item in the excel so that i can write into the specific row output column. Kindly help to achieve this.
TIA
Ramya A
1 Like
@ramya_anbazhagan,
You don’t need to find the index of the row if you are using ReFramework. TransactionNumber could be used as index here.
If not using ReFramework, you can use Find/Replace Value activity to find the row you wanted.
Thanks,
Ashok 
hi @ramya_anbazhagan,
Can you share a demo of your input and output excel please?
You can set a starting row index of your output (like, if you have a header row, you can start with row 2 for status), then increase the value by 1 for each transaction and update status cells in specific column(s).
Hi Ashok, Just realized and coded it too! 
It is working and thanks!
1 Like
@ramya_anbazhagan,
Wonderful! Kindly mark the answer as solution and close this thread 
Thanks,
Ashok 