Finding Row index in excel

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 :slight_smile:

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! :smiley:
It is working and thanks!

1 Like

@ramya_anbazhagan,

Wonderful! Kindly mark the answer as solution and close this thread :smiley:

Thanks,
Ashok :slight_smile: