is there any way to add row by row in each loop data to excel without overwriting previously added data?
I want robot to read value in citrix and if condition is not met, I want it to write the current variable to excel - hence since it is looping through hundreds of values I expect it to write in each loop to different row and not overwrite existing - previously written data - hope it is understandable.
I tried building data table and adding new rows with data and in the end adding data table to excel, but that is not very useful in this specific process as sometimes it stops because of citrix itself and robot needs to start again and loses previously added data in data table. So I would appreciate if you could give me a hint how can robot write new value not to data table but directly to excel each time/loop to new row.
Thanks @arivu96 , you are write, I can use counter to determine cell reference. What if I didn’t know where already existing excel text ended and hence where should start the robot? (I wouldn’t know exact cell)
May I ask a similar question… I want to write to a specific excel row, but do not want to override the data. Can I insert a new row above, and then write into the new row ?
Many thanks for your prompt advice. Would you mind giving further instruction on this : )
Assuming I need to insert a new row at row 12 to the DataTable named DT, should I use Assign activity to:
DT = DT.Rows.InsertAt(12,1) ?
then write data to this row, and use Write Range to write back the whole datatable back to the excel worksheet ?