Identifier expected error in read cell activity

Help
1

I get identifier expected error in read cell activity in excel. The read activity is within a loop. It is bizzare that the first instance ( i=1 ) from the excel is read properly, however all subsequent instances throw an identifier expected error. My read cell ouput is stored in a Generic Variable. The cell which the code reads from Excel has a Vlookup formula.

2

HI @Abhi12

Will it be possible for you to share your workflow or a screenshot? that will be easy to understand the issue

3

UIPATH%20snap
UIPATH%20snap1377×1000 55.2 KB

Image on top is snap of excel. Step 1 check if value in column F is “non” . if Non, read values in corresponding column B , C , D, E .

The snap left bottom stores value read from column F in variable oui_non, then it starts reading columns B C D E. The coulmn D whose value is stored in Modèle (pic bottom right). It contains RechercheV ( French for Vlookup) in it.
The code runs first time i.e for first time it reads the “NON” value. For the second time, the code throws Identifier expected error when it reads values in column D.

4

UIPATH%20snap
UIPATH%20snap1377×1000 55.2 KB

Image on top is snap of excel. Step 1 check if value in column F is “non” . if Non, read values in corresponding column B , C , D, E .

The snap left bottom stores value read from column F in variable oui_non, then it starts reading columns B C D E. The coulmn D whose value is stored in Modèle (pic bottom right). It contains RechercheV ( French for Vlookup) in it.
The code runs first time i.e for first time it reads the “NON” value. For the second time, the code throws Identifier expected error when it reads values in column D.