Get row item


#1

Hi,

Can anybody tell me how to get all values from an excel sheet. I tried using get row item, with column 0, I got LIST. But after that, I am getting spaces for all row items. Same for the next row.

ACTION PASSWORD MDL_CD MDL_YR ACCY_CD
LIST ECHO 18 2018 D7
ADD ECHO 18 2019 D7


#2

Use read range and then you can get all values in datatable @abdul Then you retrieve values from datatable


#3

Hi there, try this:

  • Read range activity, it will output a Datatable

  • Use for each row activity with that Datatable.

  • If you want see the result of the read, print the datatable with a new write excel activity

Regards :mage: