Create a excel datable using reframework


My requirement is as follows:

  1. Using reframework reading excel file.
  2. In excel there will be three columns.
  3. 1st column will be Words say - Hello, umberalla etc.
  4. In 2nd column it will have as English and header of the column will be From.
  5. In 3rd column it will have as Spanish and header will be To.
  6. Now, I want to pick each data from column 1.
  7. Translate the Word to spanish and save it in new 5th column.
  8. My doubt is in process state how can we build datatable?.

@Palaniyappan @lakshman

1 Like

We can build the datatable while initiating the process itself with Init State
And get the output of that activity build datatable activity with a variable of type datatable named Finaldt
—then this variable can be passed either as a argument or as a global variable to Process state and use ADD DATAROW activity and pass the values we want with ArrayRow property like this

Cheers @monish06