Hello, I am needing one help for this job please and if be possible, one example
Using the Excel file in attached, I am reading ALL values of “A” Cell and depending the value into this cell, I need put the “Situation” into the cell (“E”).
I am getting to write ONLY the first row and iteration is not working for others rows.
I tried put in Write Cell, “E2” + VAR1 but it not working)
My main activities are:
Variables:: InputDataTable , CodeValue, ContentValue e VAR1.
1- Excel Application Scope
2- Read range the Excel File. (var: InputDataTable)
4-For Each Row.
5- Assign ( CodeValure = row(“CNPJ”).ToString.Trim)
6- If condition (CodeValue = “02773629000280”)
7- THEN Write Cell (“E2”) “OK” ELSE Write Cell “NOK”
8- Assign (VAR1 = VAR1 + 1)
Could you please give me one example for this iteration and IF CONDITION?
THANKS A LOT!
Test.xlsx (9.1 KB)