Try catch for each rows in Datatable

Hi, I have a for each Excel loop in which an error can occur. If the error occurs, “Error” should be written in a line in the try catch activity. Unfortunately, my attempt to do it as follows does not work, how can I solve this?


Check below for writing back to excel for your reference

Hope this may help you


Hi @NHoe

What’s the error it is showing?

You should better fix the problem than to try/catch it. Plese show the formula and name the occuring exception.

click on exception drag one log message>> in log message put exception.message and comment the assign in finally
message will be printed in studio logs

Something is wrong with your Assign statement. Fix that first.