Read Range fails to read cell

excel

#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


#6

You can’t Concatinate the Datatables that way.

Use Merge Activity


#7


#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.