Write cell: not writing in correct cell sometimes

[dfrancis1 (Dfrancis)]

So, I have a Excel file with 4 columns that is the output of a sequence. I am using that Excel in another sequence. The flow of that sequence is as follows - Use the permit number to search. Click a couple of links. In File upload dialog box, enter file name from column 3. and in column 4, input file name + uploaded.

I am exploring UiPath on the go due to time constraints. My issue is that sometimes, after I search using a permit number, the activities following it sometimes do not get executed. In the screenshot of Excel above, the last permit number search and upload only was executed. But, it wrote the cell in the first row of the 5th column, instead of the 5th row of the 5th column.

Need suggestions on how to handle this.

[Yoichi]

HI,

Can you try either of the following?

Use CurrentIndex to create cell address.

Excel.Sheet("Sheet1").Cell("E"+(CurrentIndex+2).ToString())

Or simply use CurrentRow(“Comments”) with Assign

CurrentRow("Comments") = CurrentRow("FileName").ToString+" uploaded"

Regards,

[Anil_G (Anil Gorthi)]

@dfrancis1

as you are using for each row in excel…you can use as below

auto increment is not needed

curretnRow.ByField("Comments")

this will move as per currentrow

cheers