need to updated the status of each transaction in Excel sheet .
wat changes need to do in Set transaction status
need to updated the status of each transaction in Excel sheet .
wat changes need to do in Set transaction status
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,
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.Get Row Item
activity to retrieve the row number of the current transaction using the transaction number as the input parameter.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”:// 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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.