I have the below excel data format which I have to update.
- Read the excel sheets one by one
- Add to Queue
- Fetch transaction item
- Fetch latest stock price for the stock
- Write the latest fetched value in the specific columns --> I have trouble with this step. Will assigning the value do the job?
WriteCell or Write Range activity asks for the datatable and I am not sure how to update the data table.
Appreciate any inputs. Thanks in advance.