I have a excel with multiple sheet. I want to process each sheet in an order.If user input is 1 process sheet1,iser input is 2 process sheet 2 , similarly 4 sheets.
For all the rows in a sheet i have to update the status also.
How can I handle this situation.
I tried getting 4 sheets as main transaction and each rows in a sheet as sub transactions.But issues coming in exception handling and retries.
Can someone help me in this.