I am trying to achieve the below but could not figure out how to write the data to excel after the previous activities. Appreciate help in resolving this.
- Using For Each loop to read data from set of excel files one by one
- Add data read to queue
- Read queue entries through Get Queue Items & Get Transaction Item, pick related data from a website and update status of txn item
- Write this data to a new excel in a different path
- Email this excel to client
- The for loop continues to next excel
Need help in performing steps 4 & 5. Thanks in advance.