I have applied some vlookup formula in write cell.so in range i have write “A5”+(db2.Rows.Count).ToString but data is printing at the end .why this happened. pls help me with this
Hi Which data is printing in the end?
suggestion:- 1.create assign variable of type string
2.In the range type “A5”+dtCount
Can you show the complete vlookup statement?
Hi @ghazanfar actually it is printing all but after that it prints 0 till end .
For Example in excel suppose I have 10 rows data then upto 10 it is printing proper value after that it prints all 0.
So I thought will put counter but still it’s printing 0 after that
Please try this,
Read the excel and store it in the datatable (DB2 variable name)
Use write cell and give range as A2 or A5 (the starting row) and give the vlookup formula on value.
Use autofill range activity and give range as “A2:A” + db2.rows.count.tostring
You need to use the index count.
if you need to write from “A”+(idx+5).toString it will write from cell A5
Create a variable idx from the properties panel of for each row and pass as above in range of write cell.
As per your expression it will write at the end because its static!
Hope the above helps!