Read Range fails to read cell

Help
1

Hi All, Sample.zip (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.

Thanks

2

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

3

Thanks @vvaidya

4

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

if I assign

For each row
{
Key=A.ToString+B.toString
}

Write Range - Key → “C1”

Will this work

5

image.png551×779 17.3 KB

6

You can’t Concatinate the Datatables that way.

Use Merge Activity

7

image.png413×590 19.6 KB

8

Thanks @vvaidya

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

9

Hi,

Please follow below tutorial,

Thanks,
Karthik.