Read Range fails to read cell



Hi All, (8.1 KB)

I am trying to read a range and process the rows inside that range, looks like the read range is running but not recognize the rows. I have attached the code and sample xls. I would appreciate your suggestions.



row(0).ToString in 1st Message Box instead of A.ToString


Thanks @vvaidya


Still it returns empty message box, I am trying to ultimately concatenate data table A and B together

if I assign

For each row

Write Range - Key -> “C1”

Will this work



You can’t Concatinate the Datatables that way.

Use Merge Activity



Thanks @vvaidya

Now it opens a new issue … last concatenate is copied over to all (7.7 KB)



Please follow below tutorial,