Thank you for the solution!
It works but I decided to go against using it in production due to the concern of this performance. By using If Else to write lines it took me around 5mins, due to the number of records in needs to go through.
Here is what I did instead.
As my output table is generated from PowerQuery, I build an additional Custom Column in PowerQuery where [Status] = 100.
Once the output table is generated I created an assignment in UIpath for Status.
ColumnAlltable.DefaultView.ToTable(false, ColumnAlltable.Columns(“Status”).ColumnName )
Once the assignment is created, I simply use ExcelWriteRange to do a paste operation from “A10”, where column = Status
Total time for this alternative solution less than 10 secs.