Excel Activities Empty Column , Go Next Cell

Help Activities
, ,
8

Use the "Read Range activity to read the first row.
Iterate through columns using a For Each loop to find the first empty column.
1.Use "Write Cell"to write data in that column.
Alternatively we can use Vb.net
Go to the Next Cell

  1. Read data using “Read Cell”
    Identify the next row (CurrentRow + 1)
    Use “Write Cell” to move to the next cell.

  2. Go to the Right Cell
    Move right using “Column Index + 1” and write data using “Write Cell”.

  3. Go to the Left Cell
    Move left using "Column Index - 1"and write data using “Write Cell”.

  4. Go to the Next Empty Cell
    Use “Read Range”, loop through the cells to find the first empty one, and use “Write Cell” to insert data.
    It would be great if UiPath could introduce built-in navigation activities for these common Excel operations.