I need to do a data entry from an Excel to a website which works perfectly fine.
So I uploaded my excel and stored in a datatable.
I used a For Each row of my datatable and have a Body with all my Type Into activities.
I want to write “Success” in a column after each full entry it has done - I suppose at the bottom in my For Each Loop.
I only want “Success” as the robot will stop if any error.
Okay thanks. I have one more question. Suppose I have 100 entries and I STOPPED the robot at 50. The “Success” will not be written in the Excel as the Write Range is outside the For Loop.
So I should have a write range in the For loop itself?
please use for loop inside try catch , so if you have no error after for loop in try the data table will be write to excel, or if you have any error in catch you also have to write the data table in excel. based on this logic even when error occurs the current updated data table will be written in the excel.
For loop inside try catch , may be after every loop you can use write range so that we can avoid data loss, even if you stop the bot or error comes (because we use write range inside catch also) it will update the latest data in excel.
hi, Dear, my excel file has a column called “Status”,but I tried you method below,
[In assign activity left side give row(“Status”) and in right side give “success” it will automatically update value in specific row.]
it is not writing to my file. The column “Status” is empty, would you please help?
Thanks in advance.
At the end of the process did you use write range activity because we updated the value in datatable only ,and if we want to update in excel we have to use write range activity (pass the excel file path and datatable)
if I use write cell there is another question, the cell need to be dynamic, for example, the Status is dynamic, and write from B2 to B30
But the cell here writes B2.