Build Re frame work with Orchestrator/Queue

need to updated the status of each transaction in Excel sheet .

wat changes need to do in Set transaction status

@Tejaswini_Yadav1

Just add add datatrow to a datatble with required data and append range activity(in success,bus excep and sys Excep) so that for each transaction it would append a row to excel report

and include a create report with column names and all in initialize so that you have a report available

Hope this helps

cheers

Hi @Tejaswini_Yadav1 ,

Hope this might help you to update the status in Excel using Re Framework:

Regards,

1 Like

@Tejaswini_Yadav1

  1. Add a new column to your Excel sheet to store the transaction status. For example, you can add a new column called “Status” to your transaction data sheet.
  2. In the Process.xaml workflow, after processing each transaction, you can use the Write Cell activity to update the status of the transaction in the Excel sheet.
  3. To do this, you need to retrieve the row number of the current transaction in the Excel sheet. You can use the Get Row Item activity to retrieve the row number of the current transaction using the transaction number as the input parameter.
  4. Once you have the row number, you can use the Write Cell activity to update the status of the transaction in the “Status” column. For example, you can use the following expression to update the status of the transaction to “Successful”:
  5. Repeat steps 2-4 for each transaction in the process.
// Get the row number of the current transaction
rowNumber = transactionNumber + 2 // Assuming the transaction data starts at row 2

// Update the status of the transaction in the "Status" column
status = "Successful" // Or any other status you want to set
cellAddress = "C" + rowNumber.ToString // Assuming the "Status" column is column C

Thank you for all suggestion .
It Resolved

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.