I have issue in for each workflow

[Arivu]

Hello everyone I have issue in for each workflow help to solve this issue

[rlgandu (Rajyalakshmi Gandu)]

@Arivu

"E"+(Var1+2).ToString

Var1 is of Type Int

[ppr (Peter Preuss)]

We would assume that CellId should reflect a number, but see a modeling that is of datatype string.

So at this part, the modelling has to be modifyed

[Krishna_Raj]

@Arivu
1.check your cell id variable and its increment the values so you can use for each index also
2. change cell id variable type to integer
3. check below reference

Write in excel sheet

in for for each you will give the your data for iteration you can give the currentindex if not present for you otherwise you will get it automatically for new version of packages [image] in write cell you will the index for increament [image] Hope this helps Regards

its works means

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…

[singh_sumit (Sumit Singh Tariyal)]

Hie @Arivu so if i"m not wrong you are write data on each cell and increament it with one cell like first bot should write on cell - example - D2 and After that D3 write if yes then
you should make a variable of integer
and in the write cell pass “D”+(count+1).ToString

this way you can do
mark this solution if it work for you
happy Automation

[naveen.s]

@Arivu ,

I hope you are using the for each loop, just create a variable in for each(index)

And pass the variable in cell(in write cell activity) as “D”(Row+2).tostring

Make sure the datatype of the row which you created in for each is int datatype

[mkankatala (Mahesh Kankatala)]

Hi @Arivu

You are not adding the +2 to the Integer value, you are making it as String.

In your case Celid is Integer variable and you are adding 2 to it then you want to store again to Celid. Then give the expression as below in assign activity,

- Assign -> Celid = (Cdbl(Celid.toString)+2).toString

Then pass this variable to the Write cell workbook activity as,

"D"+Celid.toString

Check the below image for better understanding,

Hope it helps!!