For each excel row, fill up to cell 15th if cell is empty

[supermanPunch (Arpan)]

@Ben_siu ,

Could you check with this Method as shown in the Image :

After reading the Excel sheet as a Datatable, use a For Each Row in Datatable Activity and inside it put the below Expression in an Assign Activity.

CurrentRow.ItemArray = CurrentRow.ItemArray.Select(Function(x)if(String.IsNullOrWhiteSpace(x.ToString),"YourString",x.ToString)).ToArray

Then use a Write Range Activity to write the updated datatable back to excel sheet.