How to write data to excel using each row activity?

Help IT Automation
1

Hello,

I have the below excel data format which I have to update.
image

  1. Read the excel sheets one by one
  2. Add to Queue
  3. Fetch transaction item
  4. Fetch latest stock price for the stock
  5. Write the latest fetched value in the specific columns → I have trouble with this step. Will assigning the value do the job?

image

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.

Regards,
Manjari

2

@anon24920977

You can use Build Datatable activity-> define your columns then you can give the value as

datatable.Rows(index).Item(“ColumnName”) = Variable Name

You can see the below, how we need to set the value to a Datatable

Hope this helps you

Thanks

3

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