Xls Output after error erase last cells info

Help
, , ,
1

Hi! I have a process that writes line by line an output in excel but the problem is when there is an error and I have to restart the robot , it starts correctly processing from the last line (in green) but what was written in the lines before (in red) it goes out. Any ideas on how to get around this? Thank you guys!image

2

Hi Pedro,

Is it possible that the workbook is not being saved? Maybe putting a Save Workbook activity at the end of each loop would help solve this problem.

Many thanks,

Ryan.

3

Thanks but I don’t think that’s the situation because I have a save workbook at the end of for each. What happens is that, if it fails, the robot creates DT based on the saved workbook but deletes the lines that were saved before.