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

Help Activities
, , ,
8

Hi @Ben_siu,

You can try the following steps to get the required output:

  1. Read a excel file using read range activity.
  2. Use for each loop to get each row of a DataTable and create index variable in foreach activity.
    Note: For Each Row index variable will help to identify the row throw index value.
  3. Use while loop activity under For Each Row. In while loop put a condition so that it run 15 times. Create index variable in while also.
    Note: While Loop index variable will help to identify the col throw index value.
  4. Use If activity under the While loop and check whether the cell value is blank or not. Pass Col index variable in current row to read the cell value.
    5 If the cell is blank then write the cell using write cell activity.

image

Regards,
Rohit