Write cell in LastRow problem

[Petar_Soce]

The program writes “Lorem ipsum” at the last row 10845… How to tell him to count xlUP

I want the data in C3 and next data in C4 and continue

[rkelchuri (ER.Krishna)]

Update each row in an Excel document

I currently read an excel file into a datatable in uipath. Based on the data in each row, I perform a sequence of activities in an application and then write the result in a new column of the row. When I’m done processing all the rows and everything goes fine, everything is copied back to the excel file and saved. Everything works fine at the moment. The problem is that if a failure occurs in the application while processing a particular row, the system crashes and the already processed/updated …

[prassin6 (Prashant Singh)]

@Petar_Soce This might be of help

Excel Sheets

Use while loop - if the same data needs to be entered in the entire column. [col] Just an Idea !! If different data needs to be entered in different cells then, probably send HOT Keys like Down and the cursor will go down one cell in the same column and write the data . keep repeating it until a condition is met.

[Petar_Soce]

Thank you. All of this :

is inside for each loop. Right now it writes the first value in thr specified row but when it comes in the second turn it overwrites that value.
I cant understand why “indexofrows” always gives out -1 as a result. If the first is -1 and i write some value in that -1 field then on the second turn index of row should be -2 or something. But it gives -1 again. I cant share my workflow due to the sensitivity of data. Thank you

[Petar_Soce]

I have managed to solve my problem so if anyone comes accross this , this is what I did: